<?php
class City{ 
    function read_all_city($db){ 
             $cities = $db -> return_result("SELECT ac.`id`,astate.provDesc, ac.`citymunDesc` FROM `all_city`  ac 
LEFT OUTER JOIN all_state astate
ON ac.provCode = astate.provCode
WHERE ac.status = 1 ORDER by ac.`citymunDesc` ASC");
                    $json = [];
                    foreach($cities as $city){
                         $json[] = ['id'=>$city['id'], 'text'=>$city['citymunDesc'].' - ('.$city['provDesc'].')' ];
                    }
                    echo json_encode($json); 
    } 
 
} 
?>