How to build a query correctly?

Question

Laravel

I need to find a model1 that has a model2, where model2 has a number greater than the number of model 1 by 10
, I try like this:

Model1::whereHas('model2', function ($query){
    $query->where('number',  '>',   $model1->number+10)
});

How to use $model1 in the wherehas function?

Answer 1

You need to do it through mysql because at the query level you don't have $model1
something like this

Model1::whereHas('model2', function ($query){
    $query->whereRaw('number',  '>',   'model1.number+10')
});