Query to find users who are in more than one user group
If you're looking for a SQL query (as opposed to an element query), then you can use this:
SELECT userId FROM craft_usergroups_users GROUP BY userId HAVING COUNT(*) &gt; 1;

This only gets the userId.