yii2-basic-app- все статьи тега

как написать условие if внутри условия where на основе подзапроса в Yii2 query builder

У меня есть подзапрос внутри основного запроса, как показано ниже: $subquery = (new Query())->select('COUNT(project_sup_id)') ->from('project_supervisors AS sup') ->where(['AND','sup.project_ref_id = p.project_id']); $uQuery =(new Query())->select(['project_id','supcount' => $subquery]) ->from('projects AS p') ->join('LEFT JOIN','project_supervisors AS sup','sup.project_ref_id = project_id') ->andWhere('IF(supcount>0, sup_project_status=1, projec ...