You can create a query that returns a table of tickets, including the email address of each ticket's owner (user). To do this, you can cross-reference from the tickets table to the person table using: 

tickets.person.primary_email.email

 e.g.:

SELECT tickets.id, tickets.subject, tickets.date_created, tickets.person.primary_email.email
FROM tickets

 which would give you a table like this: