Can I query the database to get a project role user and jira id?

[Nic Brough -Adaptavist-]

Yes, but it's a pain, you're better off using the API.  (Join project_role_actor to cwd_user, but you'll need some more joins to work out what exactly to read)