Good question, I was also looking for a query to tell me quickly which grp does a domain\user belongs to, the closest I think is(not a complete answer), xp_logininfo

EXEC XP_LOGININFO 'domain\groupname','members'

EXEC XP_LOGININFO 'domain\groupname','all'

-- let me know if there is another easier way.