Yii2框架 *** 作数据库的方法分析【以mysql为例】

select id,username from customer where id in(select distinct id from order where order_state=1)

---