Jira: List users assigned explicitly to project roles

Assigning people to project roles explicitly is a bad habit, you should avoid it, as it will lay much work on your shoulders when a user's privileges will be changed.

SELECT actor.roletypeparameter AS username, r.name AS rolename, p.pkey, p.pname AS projectname
FROM projectroleactor actor
INNER JOIN cwd_user u ON u.lower_user_name = actor.roletypeparameter
INNER JOIN projectrole r ON actor.projectroleid = r.ID
INNER JOIN project p ON actor.pid = p.ID;