Find Database User and Role

SELECT 
    RoleP.name AS DatabaseRoleName
    ,ISNULL(UserP.name, 'No members') AS DatabaseUserName
    ,UserP.principal_id
    ,UserP.create_date
FROM sys.database_role_members AS DRM  
RIGHT OUTER JOIN sys.database_principals AS RoleP ON DRM.role_principal_id = RoleP.principal_id  
LEFT OUTER JOIN sys.database_principals AS UserP  ON DRM.member_principal_id = UserP.principal_id  
WHERE RoleP.type = 'R'
and
UserP.name = 'my-name'
ORDER BY RoleP.name, ISNULL(UserP.name, 'No members');