app\controllers\ConfController::actionIndex PHP Method

    public function actionIndex()
    {
        // 为了方便用户更改表名，避免表名直接定死
        $groupTable = Group::tableName();
        $projectTable = Project::tableName();
        // 显示该用户为管理员的所有项目
        $project = Project::find()->leftJoin(Group::tableName(), "`{$groupTable}`.`project_id`=`{$projectTable}`.`id`")->where(["`{$groupTable}`.`user_id`" => $this->uid, "`{$groupTable}`.`type`" => Group::TYPE_ADMIN]);
        $kw = \Yii::$app->request->post('kw');
        if ($kw) {
            $project->andWhere(['like', "name", $kw]);
        }
        $project = $project->asArray()->all();
        return $this->render('index', ['list' => $project]);
    }