public static function regionsByMahala (){
$sql = "SELECT rrr.id, rrr.name_ru, rrr.name_uz, rrr.name_en
FROM `ref_mahala` rm
LEFT JOIN ref_region rr ON rm.district_id = rr.id
LEFT JOIN ref_region rrr ON rr.parent_id = rrr.id
GROUP BY rrr.id";
$connection=Yii::app()->db;
$db = $connection-> createCommand($sql);
$row = $db->queryAll();
// $db = RefMahala::model()->findBySql($sql);
return $row;
}