You can get this information from the Pyramid repository, assuming you have access to it.  Here is an example query that you can use:

SELECT
  u.id AS UserID
, r.id AS RoleID
, p.id AS ProfileID
, u.user_name AS UserName
, r.role_name AS RoleName
, p.name AS ProfileName
FROM content_tbl_user u
INNER JOIN role_tbl_user_role ur ON u.id = ur.user_id
INNER JOIN role_tbl_role r ON ur.role_id = r.id
LEFT JOIN role_tbl_profile_role pr ON r.id = pr.role_id
LEFT JOIN role_tbl_profile p ON pr.profile_id = p.id

Feel free to add additional columns as needed. If you have users that belong to multiple roles, you will see them listed multiple times in the query results.