$model = JobProfile::model()->with(‘userrelationname’,’categoryrelationname’)->findAll(array(“condition”=>”t.category_id =1 and t.experience =2 and t.key_skills LIKE ‘%PHP%’“));
您可以在JobProfile模型中找到关系名称
关系示例
public function relations(){
return array(
'user' => array (self::BELONGS_TO, 'User', 'id' ),
)
}
然后在您的控制器示例中;
foreach($model as $m){
echo $m['user_id']; // in your job_profile table
echo $m->user->id; // in your user table
}