问将PHP foreach循环从最低到最高排序

EN

    $tempArr = array();
    foreach($results as $row){
        if($row['basic'] != ""){
             $minrate = $row['basic'];
        }elseif($row['standard'] !=""){
             $minrate = $row['standard'];
        }elseif($row['premium'] !=""){
              $minrate = $row['premium']; 
        }

        //Make the $minrate the key - Will be easy to sort | Make a multi dimensional array, incase duplicate on $minrate
        if ( !isset( $tempArr[ $minrate ] ) ) $tempArr[ $minrate ] = array();
        $tempArr[ $minrate ][] = $row;
    }

    //Sort an array by key
    ksort( $tempArr );

    //Make Multi dementional array to single array
    $sortedResult = array();
    foreach( $tempArr as $tempArr2 ) {
        foreach( $tempArr2 as $value ) {
            $sortedResult[] = $value;
        }
    }

    //$sortedResult <-- As the variable says, It should be sorted
    echo "<pre>";
    print_r( $sortedResult ) ;
    echo "</pre>";

   SELECT 
    users.id, 
      case when  rates.basic is not null then 0
           when  rates.standard is not null then 1
           when  rates.premium is not null then 2 
          end as my_rate,
      case when  rates.basic is not null then 'BASIC'
           when  rates.standard is not null then  'STANDARD'
           when  rates.premium is not null then  'PREMIUM'
          end as my_rate_text    
      FROM rates, users WHERE rates.`rate_id` = users.`id`
      ORDER BY  my_rate
      ;