Can I use ar in yii for nesting?

Can I use ar in yii for nesting?

$ C = new CDbCriteria (); $ c-> join = "left join (select goods_id, group_concat (name) as 'tags' from goods_tag group by goods_id) 'tag' on tag. goods_id = t. id "; $ res = Goods: model ()-> with ('brand')-> findAll ($ c );

Similar to the above query (The above is incorrect, but the tags field cannot be found), can yii use ar to query? How do I perform this operation?

Reply to discussion (solution)

Is there a write rule in relation? Let's take a look at the source code of CActiveRecord. you can't use SQL directly.

It is easier to use createCommand.