Filter userlist results

im edting the userlist to only show users from a cirtin group.

( i want to show a selection of groups on one page)

i only want group 1 (admins) to show up in the list?

how would i do this?

mysql would be

SELECT `group_id` , `username` , `realname`
FROM `pun_users`
WHERE `group_id` =1
ORDER BY `group_id` ASC
LIMIT 0 , 30

DONE.

// Grab the users
$result = $db->query('SELECT u.id, u.username, u.title, u.num_posts, u.registered, g.g_id, g.g_user_title FROM '.$db->prefix.'users AS u LEFT JOIN '.$db->prefix.'groups AS g ON g.g_id=u.group_id  WHERE `group_id` =1');
if ($db->num_rows($result))
{

i simpled it down a bit for me but