How can I make this conditions with eloquent? I want all records with product and category table whose url_name equals to $variable_name.
Here is the code:
\App\Product::with(['category' => function ($query) { $query->whereHas('url_name','Summer-Collection'); }])->get(); You just need to pass the variable to the closure using use:
$variable_name = "something"; \App\Product::with(['category' => function ($query) use($variable_name) { $query->where('url_name', $variable_name); }])->get(); 
Assuming that the url_name is on the category table, and you have a relation setup on the Product Model you would do something like this.
$variable = 'Summer-Collection'; \App\Product::with(['category'])->whereHas('category', function($query) use($variable) { $query->where('url_name','=',$variable); })->get(); 
whereHas works with relationships and cannot be used as a where clause.
$variable_namenot being defined? If so you will just need to adduse ($variable_name)after the function parameters to put it within scope. If not, please add more detail to your question. Or even if that is the problem, include it in your question.Product::with(['category' => fn($q) => $q->whereHas('url_name', $variable_name)])->get();No need to import variables from parent scope with arrow functions.