mysql 查询关联表 左外查询 排除相同的部分

查询关联加条件查询：
$listQuery = BusinessOrderModel::whereIn('business_order.bms_id', $userinfo['bms_id_arr'])->whereIn('business_order.status',$status)->leftjoin('business_order_goods','business_order_goods.order_id','=','business_order.id')->where('business_order.pay_status',1);
      if(in_array(2,$status)){
         $listQuery->whereNotIn('business_order.id', function ($listQuery) {
              return $listQuery->from('business_order')->select('business_goods_return.order_id')->leftjoin('business_goods_return','business_goods_return.order_id','=','business_order.id')->whereIn('business_goods_return.status',[0,1,2]);
          });
      }

闭包查询 使用use 传递参数
$users = User::whereNotIn('id', function ($query) use($user){
            $query->select('toUserId')->from('relation')->where('relation.userId', $user->id);
});