How to get data without connection?

Question

Yii

return Project::find()
            ->leftJoin('project_user', 'project_user.project_id = project.id')
            ->select(['project.id', 'project.title'])
            ->where(['!=', 'project_user.user_id', $user_id])
            ->asArray()
            ->all();

I need to get all projects that do $user_idn't have a link in project_user. How to do it?
The problem with this query is that it will still return a project with which the user has no connection if the table project_userhas a connection with another user (that is, if there are 1 or more records with this project).

Answer 1

return Project::find()
    ->alias('p')
    ->leftJoin('project_user pu', 'pu.project_id = p.id and pu.user_id = :userId')
    ->select(['p.id', 'p.title'])
    ->where(['pu.user_id' => null])
    ->params(['userId' => $user_id])
    ->asArray()
    ->all();