How to do join in Laravel if belongTo is used?

Question

Laravel

Hello!
Laravel started using recently.
i have working code

return Tour::find($tour->id)->trips()
                ->where('active', '=', '1')
                ->orderBy('top', 'sort')
                ->paginate(10);

The ' trips ' table has a ' trip_places_id ' field and there is a ' places ' table from which you need to extract a record if
trips.trip_places_id = places.id
But I don’t know how to make a join correctly.
Sincerely, Konstantin.

Answer 1

So write:

return Tour::find($tour->id)->trips()->with('places')
                ->where('active', '=', '1')
                ->orderBy('top', 'sort')
                ->paginate(10);

Of course Trips must have a relationship places -> belongsTo('Place')