T-SQL query to find members of a Database Role

Here is a T-SQL query to find members of a Database Role

USE SansSQL --Change the Database Name
GO
SELECT USER_NAME(memberuid) AS Member ,USER_NAME(groupuid) GroupName FROM sysmembers
ORDER BY member