PHP MYSQL ช่วยแนะนำ การ Query ให้แสดงผลใน 1 แถวหน่อยครับ

$new_ar = array();
while($ro=$rs->fetch_assoc()){
    if(!isset($new_arr[$ro['nu_code'])) $new_ar[$ro['nu_code']]=array();
    $new_ar[$ro['nu_code']][0]=$ro;
}

foreach($new_ar as $ro_list){
   foreach( $ro_list as $idx=>$ro){
        if ($idx==0){
            echo $ro['id'], $ro['nu_code'], $ro['unit'];
        }
        echo $ro['so_name'], $ro['i1'], $ro['u1'];
   }
}