查询重复订单select openid from `#_order` where openid in (select openid from `#_order` group by openid having count(1) > 1) group by openid;
