SELECT groname, usename 
FROM pg_group,pg_user 
WHERE usesysid = any(grolist);