Lemmy

select person.id,name,local,local_user.email from person join local_user on person.id = local_user.person_id where person.id =2;

id | name | local | email

----+-----------+-------+---------------------

2 | BlueEther | t | firstname@lastname.nz

Email is only available for local users and only if filled in on the signup form