Laravel with eager where

Eager realationship in laravel

$parentLineCategories = ProductCategory::with([
            'children' => function ($child) use ($SpecificID) {
                return $child->with([
                    'products' => function ($product) use ($SpecificID) {
                        return $product->with([
                            'types' => function ($type) use ($SpecificID) {
                                return $type->where('id', $SpecificID);
                            }
                        ]);
                    }
                ]);
            }
        ])->get();

Source: stackoverflow.com

Similar codes

-2 votes368 views1 answer
Laravel if else condition in query
PHP Laravel
50 votes465 views6 answers
Laravel migration add column to existing table
PHP Laravel
5 votes319 views3 answers
Laravel display error message
PHP Laravel
0 vote342 views3 answers
SQLSTATE[42S02]: Base table or view not found: 1146 Table many to many in laravel
PHP Laravel
0 vote369 views2 answers
Laravel pagination layout issue
PHP Laravel
6 votes332 views4 answers
Insert data using seeder in laravel
PHP Laravel
8 votes386 views4 answers
Laravel between dates
PHP Laravel
0 vote379 views1 answer
Test lockForUpdate laravel
PHP Laravel
0 vote363 views1 answer
Laravel get query in normal sql without bindings
PHP Laravel
1 vote340 views1 answer
Laravel validate enum field
PHP Laravel