Laravel Multi-Table Joins: Step-by-Step Guide

1 year ago
Ava Mitchell
1 minute

You can perform multiple table joins in Laravel using Eloquent ORM. Here is an example:

$users = DB::table('users')
    ->join('posts', 'users.id', '=', 'posts.user_id')
    ->join('comments', 'posts.id', '=', 'comments.post_id')
    ->select('users.*', 'posts.title', 'comments.comment')
    ->get();

In this example, we started by selecting the users table and joining it with the posts table and comments table, then we selected the desired fields to retrieve. Finally, we used the get() method to fetch the results.

In addition to using the DB Query Builder, you can also use Eloquent relationships for performing multi-table joins. For example, if you have a User model, a Post model, and a Comment model, you can define their relationships and perform queries using Eloquent relationships. Here is an example:

$users = User::with('posts.comments')->get();

In this example, we use the with method to load the relationship between posts and comments. This will return all users with their respective posts and comments.

bannerAds