Laravel eager loading sub relations with limit and custom fields

Question

I have custom query where I get services by grouping city and select from services table only custom fields by loading there reviews:

$services = City::select('id')
                ->has('services')
                ->with([
                    'services:id,title',
                    'services.reviews'
                ])->get();

In this case I need to only 3 reviews to each service with reviews custom fields. For example I need from reviews table only description and rate. How I can do it in my case?

Does this answer your question? [Limiting the result of nested relationship in Laravel](https://stackoverflow.com/questions/55991576/limiting-the-result-of-nested-relationship-in-laravel) — shock_gone_wild, Sep 08 '20 at 09:44

score 0 · Answer 1 · answered Sep 08 '20 at 09:45

You could just create a relationship that limits the child to three rows. Then you'll have the ability to specify what columns you want to show in the same way you did with services.

So for example, in the Service model, add something like:

public function threeReviews() {
    return $this->reviews()->take(3);
}

Then use it the same way you use the services.

->with(['services:id,title','services.reviews:description,rate'])

Laravel eager loading sub relations with limit and custom fields

1 Answers1