SELECT users.name AS user_name, users.friendly_name AS user_friendly_name, users.licensing_role_name, users.domain_name, sites.name AS site_name
FROM _users users
INNER JOIN _sites sites
ON users.site_id = sites.id
WHERE domain_name = 'add domain name here'
AND users.licensing_role_name = 'Interactor'
ORDER BY users.name ASC;