SQL Query
select t1.USER_DISPLAY_NAME
from ubbt_USERS as t1,
ubbt_USER_GROUPS as t2
where t2.GROUP_ID='6'
and t1.USER_ID = t2.USER_ID

Change 6 to whatever group number you want.