SQL INNER JOIN

SELECT *

FROM roles INNER JOIN roles_users

ON roles.id = roles_users.role_id

WHERE roles_users.user_id = 73

ORDER BY roles.name