join('yz_order_pay_order as opo', 'o.id', '=', 'opo.order_id') ->join('yz_order_pay as op', 'op.id', '=', 'opo.order_pay_id') ->where('o.status',0) ->where('op.status',1) ->pluck('o.id'); } }