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

<?php

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(
                'categories.*',
                'categories.name',
                'sub_category.name as sub_category_name'
            )
            ->leftjoin(
                'categories as sub_category',
                'sub_category.category_id','=','categories.id'
            ) 
            ->get();

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

We always thanks to you for reading our blogs.


dharmesh-image

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-image

Haresh Chauhan

(Co-Founder)


We Are Also Recommending You :