is there a way to get roles for a site member by querying it?

I know we can get the user role for a site member currently logged in. but how can we query the members database and get the role for all users instead? I need to display the role names in a repeater for the contact/member.