如何关联多个连接CDbCriteria Yii 1.1

// 创建主CDbCriteria对象
$criteria = new CDbCriteria;

// 添加主表查询条件
$criteria->select = 'column1, column2';
$criteria->condition = 'column1=:value';
$criteria->params = array(':value' => $value);
$criteria->order = 'column1 ASC';

// 创建关联CDbCriteria对象
$relatedCriteria = new CDbCriteria;

// 添加关联表查询条件
$relatedCriteria->select = 'related_column';
$relatedCriteria->condition = 'related_column=:value';
$relatedCriteria->params = array(':value' => $relatedValue);

// 关联主表和关联表的查询条件
$criteria->with = array(
    'relationName1' => array(
        'together' => true,
        'condition' => 'relationCondition1',
        'joinType' => 'INNER JOIN',
        'params' => array(':param1' => $param1),
        'with' => array(
            'relationName2' => array(
                'together' => true,
                'condition' => 'relationCondition2',
                'joinType' => 'LEFT JOIN',
                'params' => array(':param2' => $param2),
                // 添加更多关联表的查询条件
            ),
            // 添加更多关联表的查询条件
        ),
    ),
);

// 执行查询
$model = YourModel::model()->find($criteria);