$list = Setting::find()->alias(‘s‘)
->where([‘s.store_id‘ => $this->store_id])
->leftJoin(‘{{%qrcode}} q‘, ‘q.store_id=s.store_id and q.is_delete=0‘)
->select([‘s.level‘, ‘q.qrcode_bg‘])
->asArray()->one();
原文：https://www.cnblogs.com/liju/p/9908536.html