List of all Members of a Group with Custom Field
We use this query to get a list of the name and matriculation number of all team members:
SELECT users.name, user_custom_fields.value as matriculation
FROM users
JOIN group_users ON users.id = group_users.user_id
JOIN groups ON groups.id = group_users.group_id
JOIN user_custom_fields ON users.id = user_custom_fields.user_id
WHERE groups.name = 'Team'
AND user_custom_fields.name = 'user_field_2'
Simply insert the group name and the custom field id in the last two names.