$project = frontendmodelsProject::find() ->joinWith('catprojects', true) ->where(['category.name' => 'اندروید']) ->all();
نقل قول:
Column not found: 1054 Unknown column 'category.name' in 'where clause'
The SQL being executed was: SELECT `project`.* FROM `project` LEFT JOIN `catproject` ON `project`.`id` = `catproject`.`project_id` WHERE `category`.`name`='اندروید'
و اینم relation هام:
مدل project
public function getCatprojects() { return $this->hasMany(Catproject::className(), ['project_id' => 'id']); }
مدل catproject
public function getCat() { return $this->hasOne(Category::className(), ['id' => 'cat_id']); }
public function getProject() { return $this->hasOne(Project::className(), ['id' => 'project_id']); }
مدل category
public function getCatprojects() { return $this->hasMany(Catproject::className(), ['cat_id' => 'id']); }