Query to fetch Role name and Profile Name from User Object

SOQL:

SELECT UserRole.Name, Profile.Name FROM User

Output: