if it's a small amount of users?

SQL Query
SELECT USER_ID
from ubbt_USERS 
WHERE USER_ID NOT IN 
 ( SELECT USER_ID FROM ubbt_USER_GROUPS )

would return the orphans