For joining 4 products in each category?

Question

MySQL

there is a request

$collections_sql = Yii::app()->db->createCommand()
            ->select('t.id, t.main_image, t.title, t.alias, t.sortOrder')
            ->from('tbl_collection (
                SELECT * as c2 FROM tbl_catalog
            ) as t')
            ->join('tbl_gallery_photo gp', 'gp.gallery_id = t.id');
            if(Yii::app()->request->getParam('model_id')){
                $collections_sql->join('tbl_catalog c', 'c.gallery_photo_id = gp.id AND c.parent_model_id=:model_id',array(':model_id'=>Yii::app()->request->getParam('model_id')));
            }else{
                $collections_sql->join('tbl_catalog c', 'c.gallery_photo_id = gp.id');
            }
            $collections_sql->limit($count, ($page-1)*$count);
            $collections_sql->order('sortOrder ASC');
            $collections = $collections_sql->queryAll();

you need to make the join of the tbl_catalog table grab not all records, but 4 pieces each where c.gallery_photo_id = gp.id how can this be done, or rebuild the query?