XenForo stores secondary user groups in a varbinary list. You might not see this list in human-readable form depending on your version of phpMyAdmin or otherwise in the browse so it might look confusing.
- Compatible XF Versions:
If you need to grab all users that are in a secondary usergroup, here is the query to enter to get them.
Code:SELECT * FROM xf_user WHERE...