To expand on that, I do a join between the local_user and person tables so I can grab the name and display names for the local users:

select 
  p.name, 
  p.display_name, 
  a.person_id, 
  a.email, 
  a.email_verified, 
  a.accepted_application 
from 
  local_user a, 
  person p 
where 
  a.person_id = p.id;