Как сделать сортировку по Группам пользователей

   {if $cfg.showgroup}<div class="usr_group" style="float:right">{$usr.grp}</div>{/if}

   {if $cfg.showgroup}<div class="usr_group" style="float:right"><a href="group{$usr.group_id}">{$usr.grp}</a></div>{/if}

        //RewriteRule ^users/hobby/(.*)$ /index.php?view=users&do=hobby&hobby=$1
        $routes[] = array(
                            '_uri'  => '/^users\/hobby\/(.+)$/i',
                            'do'    => 'hobby',
                            1       => 'hobby'
                          );

        //RewriteRule ^users/group([0-9]*).html$ /index.php?view=users&do=group&group_id=$1
        $routes[] = array(
                            '_uri'  => '/^users\/group([0-9]+)$/i',
                            'do'    => 'group',
                            1       => 'group_id'
                         );
 

/////////////////////////////// SEARCH BY CITY ///////
if ($do=='city'){
.....
....
......
}
 

/////////////////////////////// SEARCH BY GROUP //////////////////////////////////
if ($do=='group'){
 
	$group_id = $inCore->request('group_id', 'int');
 
	$querysql = "SELECT u.*, p.*, u.id as id, u.regdate as fregdate, u.logdate as flogdate
				FROM cms_users u, cms_user_profiles p
				WHERE u.is_locked = 0 AND p.user_id = u.id AND u.group_id = $group_id AND u.is_deleted = 0
				";
	$sql = 	"SELECT title FROM cms_user_groups	WHERE id = $group_id LIMIT 1";		
	$result = $inDB->query($sql) ;
 
	if ($inDB->num_rows($result)){
	$group = $inDB->fetch_assoc($result);
	$querymsg = '<div class="con_description"><strong>Поиск по группе: </strong> '.$group['title'].' (<a href="/users/all.html">'.$_LANG['CANCEL_SEARCH'].'</a>)</div>';
	}
 
	$do = 'view';
 
}