2025-11-14 09:22:18 - SQL: SELECT ug.id, ug.name, ug.slug, ug.type, ug.description,
                       COUNT(ugm.user_id) as member_count
                FROM user_groups ug
                LEFT JOIN user_group_members ugm ON ug.id = ugm.group_id
                WHERE ug.is_active = 1
                GROUP BY ug.id
                ORDER BY ug.type, ug.name
2025-11-14 09:22:18 - Result count: 6
2025-11-14 09:22:18 - First result: {"id":1,"name":"All Staff","slug":"all-staff","type":"system","description":"All active users in the system","member_count":0}