$result = Order::alias('a') ->join('user_course b','a.order_id = b.order_id') ->where('b.trainer_id',$trainer_id) ->where('a.product_type','NEQ','0') ->where('a.product_type','NEQ','2') ->select();