If this information is what you need, these queries can help you.
LIST NAME GROUPS
SELECT
g.name group_name,
user_count
FROM groups g
ORDER BY g.name ASC
LIST GROUP AND MEMBERS
-- [params]
-- string :group_name
SELECT
g.name group_name,
u.username user_name,
gu.owner group_owner
FROM group_users gu
LEFT JOIN groups g ON gu.group_id = g.id
LEFT JOIN users u ON gu.user_id = u.id
WHERE user_id > 0
AND g.name LIKE '%'||:group_name||'%'
ORDER BY g.name ASC, gu.owner DESC
LIST ALL GROUPS AND MEMBERS
SELECT
g.name group_name,
u.username user_name,
gu.owner group_owner
FROM group_users gu
LEFT JOIN groups g ON gu.group_id = g.id
LEFT JOIN users u ON gu.user_id = u.id
WHERE user_id > 0
ORDER BY g.name ASC, gu.owner DESC