Need to Sort Database Results on Various Fields

My db query is as follows:
 $query = "SELECT lm_users.users_id, lm_cdata.cfield_id, lm_cdata.value FROM lm_users
            INNER JOIN lm_cdata ON lm_users.users_id = lm_cdata.user_id WHERE lm_users.group_id =2
            AND (
            lm_cdata.cfield_id = '1'
            OR lm_cdata.cfield_id = '2'
            OR lm_cdata.cfield_id = '3'
            OR lm_cdata.cfield_id = '11'
            OR lm_cdata.cfield_id = '12'
            OR lm_cdata.cfield_id = '9'
            ) order by lm_users.users_id";
  //echo $query;

I need to have all participants organized by country, state, city without any duplicate organizations.
For example: (Need it to be alpha asc sorted)
State 1
  City
    Participant 1
    Participant 2
  City 2
    Participant 3
    Participant 4
  'No City Specified'
    Participant 5
    Participant 6

State 2
  City
    Participant 1
    Participant 2
  City 2
    Participant 3
    Participant 4
  'No City Specified'
    Participant 5
    Participant 6

Here is my code:
<?php
$stateArray = array("AL"=>"Alabama",
"AK"=>"Alaska",
"AZ"=>"Arizona",
"AR"=>"Arkansas",
"CA"=>"California",
"CO"=>"Colorado",
[..and so on...]
);

function displayEvents() {
  echo "<a name='top'></a>";
  global $stateArray;
  $res = getData();
  $are_there_any = mysql_num_rows($res);
  $uidsHostingEvents = array();
 
  $states = array();
  $countries = array();
  $event_descs = array();
  $cities = array();
  $orgs = array();

  while($row = mysql_fetch_array($res)) {
   
    if($row["cfield_id"] == 11 && $row["value"] == "yes") {
      $uidHostingEvents[] = $row["users_id"];
    }
    //event description
    if($row["cfield_id"] == 12) {
      $event_descs[$row["users_id"]] = $row["value"];
   
    } else if($row["cfield_id"] == 1) {
      $states[$row["users_id"]] = $row["value"];
   
    } else if($row["cfield_id"] == 2) {
      $countries[$row["users_id"]] = $row["value"];
   
    } else if($row["cfield_id"] == 3) {
              $cities[$row["users_id"]] = $row["value"];
   
    } else if($row["cfield_id"] == 9) {
              $orgs[$row["users_id"]] = $row["value"];
    }
  }
 
  displaySearch($stateArray, $countries);
  $otherEvents[][] = array();
  $usEvents[][] = array();
   
  foreach($uidHostingEvents as $value) {
    if($countries[$value] == "United States") {
      $usEvents[$value][] = array($countries[$value], $states[$value], $cities[$value], $event_descs[$value], $orgs[$value]);
    } else {
      $otherEvents[$value][] = array($countries[$value], $states[$value], $cities[$value], $event_descs[$value], $orgs[$value]);
    }
  }
  //actually only sorts by state
  usort($usEvents, 'compare');
 
  $str = "<a name='United States'></a><H3>UNITED STATES</H3>\n";
  $startState = '';
  $orgDisplayed = array();
 
  foreach($usEvents as $id => $participant) {  

        foreach($participant as $field) {    
          //only handle participants who have a US as their country and have a state other than NA
                  if(isset($field[0]) && $field[0] != "NA" || isset($field[1]) && $field[1] != "NA") {                
                //if this organization has not already been displayed
                if(!in_array($field[4], $orgDisplayed)) {
                      //is there even an organiation for this participant?
                              if($field[4] != "") {                              
                                    $orgDisplayed[] = $field[4];                                    
                                    if($startState != $field[1]) {
                                          if($startState != '') {
                                                $str .='<div align=right><a href="#top">go to top</a></div>';
                                          }
                                          $startState = $field[1];
                                          $str .= "</ul>\n<a name='" . $field[1] . "'></a><b>" . $stateArray[$field[1]] . "</b>\n<ul>";
                                    }
                                //ok now we have to sort cities and put participants under common cities
                                
                                    if($field[2] != "") {
                                          $str .= "\n<li>".ucfirst($field[2]) . " ";
                                    } else {
                                          $str .= "\n<li>";
                                    }

                                    if($field[4] != "" && $field[2] != "") {
                                          $str .= "<BR><b>" . $field[4] . "</b> ";
                                    } else {
                                          $str .= "<b>" . $field[4] . "</b> ";
                                    }

                                    if($field[3] != "" && ($field[0] != "NA" || $field[1] != "NA" || $field[2] != "")) {
                                          $str .="<BR>" . $field[3] . "";
                                    }

                                    if($field[0] != "NA" || $field[1] != "NA"      || $field[2] != "" && $field[3] != '') {
                                          $str .= "<BR><BR></li>";
                                }
                              } //end if not organization, do not display
                        } else {
                          // else if organization has already been displayed
                          //display event description
                        }
                  } // end if has country US and a state
        } //end foreach field
  } //end participant
 
  echo $str . "</ul>";

}
If you could offer advice. There has got to be a better way. Thank you!