How to query user information from Role?

Sample Query:

SELECT Id, Name FROM User WHERE UserRole.Name = 'Executive'

Cheers!!!