DEV Community

Laravel WhereHas() and With()

Othmane Nemli on July 06, 2021

Updates: June 2022 Laravel merged a PR (a year later from this topic) to Laravel 9, that add a new eloquent withWhereHas() -- doc This ...

Read full post

quyle92 • Aug 2 '23

thanks for great article.
Now I know that with the withWhereHas() I can load the relationship with specific condition.

HoangMoli • Aug 18 '22 • Edited

The macro should be

Builder::macro(
    'withWhereHas',
    function ($relation, $constraint) {
        return $this
            ->whereHas($relation, $constraint)
            ->with($relation, $constraint);
    }
);

if not using lambda

usamaxyz • Jan 9 '22

Thanks. I solved the same problem with inner join which supposed to be more performance efficient.

bdiazc90 • Mar 21 '22

Hello! 👋
JOIN could has better performance than WHERE EXISTS (with - eager loading), BUT:

The reason to use WITH, is for accessing models as related objects (with all their fields) instead of access a couple of fields specified in JOIN.

Othmane Nemli • Feb 6 '22

Great, would you please share your Macro?

Chidiebere Chukwudi • Jul 24 '23 • Edited

Thanks for sharing. Worthy to note that laravel now has withWhereHas eloquent method by default

Unlike in your case, where withWhereHas is a scope.

Othmane Nemli • Sep 22

of course that was helpful, instead of scoping it in each project !
I thought they'll never add it ...

zensabbah • Nov 2 '21

Hi Othmane Nemli, thanks for your article.
I have one doubt though, I didn't understand why you use the whereHas query if you just specified the condition in the first query.
Don't you get the desired result only with the "with" query+condition?

Thanks in advance

Othmane Nemli • Nov 9 '21

Thanks for reading the article.

Well, using same condition in with() and whereHas() is to prevent N+1 and get only data that you asked for in the whereHas(), so as I demonstrate the issue that we may face, the solution was to combine with() and whereHas() with same condition ..