If you have a many-to-many relationship, and you add an extra column to the pivot table, here's how you can order by it when querying the list.
class Tournament extends Model{ public function countries() { return $this->belongsToMany(Country::class)->withPivot(['position']); }}
class TournamentsController extends Controller{ public function whatever_method() { $tournaments = Tournament::with(['countries' => function($query) { $query->orderBy('position'); }])->latest()->get(); }}
Enjoyed This Tip?
Get access to all premium tutorials, video and text courses, and exclusive Laravel resources. Join our community of 10,000+ developers.
Recent Courses
[FREE] Laravel 13 for Beginners: 3 Demo Projects
5 lessons
29 min
[NEW] Laravel AI SDK: 6 Practical Examples
9 lessons
1 h 02 min
Building a Typical Laravel SaaS
13 lessons
1 h 58 min