Why does an SQL query return an empty array?

Question

Yii

Hello!!
working on yii1

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";
        return $db = RefMahala::model()->findBySql($sql);
    }

Checked Sql request in basis all correctly returns.

<?print_r(CHtml::listData(RefRegion::regionsByMahala(), 'id', 'name_ru'))?>
<?php echo $form->dropDownList($model,'parent_id', CHtml::listData(RefRegion::regionsByMahala(), 'id', 'name_ru'), array('empty'=>Yii::t("region", 'Выберите регион'), 'class'=>'span3')); ?>

But in php an empty array is returned, why? and what is wrong here?

Answer 1

Damn already found the answer, you just had to google in English

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;
    }