$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()
{
retu $this->hasMany(Catproject::className(), ['project_id' => 'id']);
}
مدل catproject
public function getCat()
{
retu $this->hasOne(Category::className(), ['id' => 'cat_id']);
}
public function getProject()
{
retu $this->hasOne(Project::className(), ['id' => 'project_id']);
}
مدل category
public function getCatprojects()
{
retu $this->hasMany(Catproject::className(), ['cat_id' => 'id']);
}