Query and Output

[Sarcoth]

My query is working the way I want it, but I'm not sure I'm displaying the output in the most efficient way. Although, it is displaying exactly the way I want.

PHP Code:

/* The usergroups that will appear on the roster */
$usergroupids = $permissions['rostermembers'];                    // the string = 40,41,42,43
$displaygroups = array();
$displaygroups = explode(',',$usergroupids);                    // convert to array

/* More selective on which fields to view from the user table */
$user_table = "user.userid, user.usergroupid, user.membergroupids, user.username, user.joindate, user.lastactivity, user.avatarid ";

/* Create the query for viewing data */
$query = "SELECT $user_table, userfield.* ";
$query .= "FROM " . TABLE_PREFIX . "user AS user ";
$query .= "LEFT JOIN " . TABLE_PREFIX . "userfield AS userfield ";
$query .= "ON user.userid = userfield.userid ";
$query .= "WHERE (user.usergroupid IN ($usergroupids) ";
$query .= "OR FIND_IN_SET(" . implode(', user.membergroupids) OR FIND_IN_SET(', $displaygroups) . ", user.membergroupids)) ";

/* Now let's run the query */
$result = $db->query_read_slave($query);

$rowcount = mysql_num_rows($result);
printf("Rows:  %d<br \>", $rowcount);

foreach($displaygroups AS $groupid) {
    printf("Group:  %s<br \>", $groupid);
    while($roster = $db->fetch_array($result)) {
        $membergroupids = explode(',',$roster['membergroupids']);
        if ($groupid == $roster['usergroupid'] || in_array($groupid, $membergroupids)) {
            printf("Username:  %s<br \>", $roster['username']);
            $charinfo['count']++;
        }
        unset($membergroupids);
    }
    mysql_data_seek($result, 0);
} 


Output
Rows: 7
Group: 40
Username: Name1
Group: 41
Group: 42
Username: Name2
Username: Name3
Username: Name4
Username: Name5
Username: Name6
Username: Name7
Group: 43

The way the output is being displayed right now, it is going through the query multiple times. The number of times is equal to how many groups there are. This won't be much of a problem if there are only 4 groups and the total number of people is low. But, I'm concerned if there are 10 groups and over 200 (or more) users. Any suggestions on a better way to display the data?

Thanks in advance for any suggestions.