Join Query Same Table In Laravel

  • 09-06-2022
  • 691
  • Laravel 9
  • Haresh Chauhan

In this post, you will learn how to do Join query in the same table or parent-child relation make using join query in laravel here below simple example given.

This case comes when I trying to make a single database table for the main category or parent and sub-category or child relation want to store in a single table.

Laravel Eloquent Parent Child In Same Table With Example


namespace App\Http\Controllers;
use App\Models\Category;

use Illuminate\Http\Request;
class CategoryController extends Controller
    * Display a listing of the resource.
    * @return \Illuminate\Http\Response
    public function index()
        // same table left join just change name
        $categories = Category::select(
                ' as sub_category_name'
                'categories as sub_category',

        return view('admin.category.category',compact('categories'));

We always thanks to you for reading our blogs.


Dharmesh Chauhan

(Swapinfoway Founder)

Hello Sir, We are brothers origin from Gujarat India, Fullstack developers working together since 2016. We have lots of skills in web development in different technologies here I mention PHP, Laravel, Javascript, Vuejs, Ajax, API, Payment Gateway Integration, Database, HTML5, CSS3, and Server Administration. So you need our service Please Contact Us


Haresh Chauhan


We Are Also Recommending You :