由于关联查询，他衍生出来的select * form User where xxx 无法避免。所以使用left join 相对而言反而查询少一些。

$query = Brand::find()->alias('b');
$query = $query->joinWith("createdUser AS c_u", true, 'LEFT JOIN');
$query = $query->joinWith("updatedUser AS u_u", true, 'LEFT JOIN');
$query->andFilterWhere([
    'b.id' => $this->id,
    'b.created_at' => $this->created_at,
    'b.updated_at' => $this->updated_at,
    'b.status' => $this->status,
    'b.sort' => $this->sort,
    'b.created_by' => $this->created_by,
    'b.updated_by' => $this->updated_by,
]);

关联方法

class Brand extends \book\models\Brand
{
    public function getCreatedUser()
    {
        return $this->hasOne(User::className(), ['id'=>'created_by']);
    }

    public function getUpdatedUser()
    {
        return $this->hasOne(User::className(), ['id'=>'updated_by']);
    }
}