This query does the job:
mysql> select r.name,r.username,r.uri,r.description,s.modified,concat("\n",s.data) as data
from users u
join users_resources_permissions urp on urp.user_id=u.id
join resources r on urp.resource_id=r.id
left join secrets s on s.resource_id=r.id and s.user_id=u.id
where u.username='XXXX@XXXXX' \G