select 
u.username 'Username',
u.email 'E-mail address',
u.fullname 'Full Name',
u.created 'Created',
u.last_active 'Last Seen',
g.name 'Group name'

from user u join usergroup g on u.usergroup=g.ref

order by username;