Project find

$query = Project::find()
    ->where(['!=', 'status', Project::STATUS_DELETED])
    ->leftJoin(UserProject::tableName(), [
        'user_id' => Yii::$app->user->id,
        'user_project.project_id' => new Expression('project_id'),
    ])
    ->groupBy('project.id');