Yii以关联表字段为条件进行查询

作个笔记，关联表的查询条件要写在with()之中

如：

        $condition = '';
        if(isset($_GET['type']))
        {
            $condition = 'audit_by_unit='.intval($_GET['type']);
        }
        $model=new CActiveDataProvider('Enrollment', array(
            'criteria'=>array(
                'condition'=>$condition,
                'order'=>'create_time DESC',
                'with'=>array('exam'=>array('condition'=>'exam.audit_user_id='.Yii::app()->user->id)),
            ),
        ));