php - How to get all children categories recursively by parent category in Laravel

I'm using Laravel 7.x and I need a proper way to get all the children + children... categories of a parent category.

category table;

$table->id();
$table->integer('parent_id')->default(0)->unsigned();
$table->boolean('is_active')->default(true);
$table->integer('sort_order')->default(1)->unsigned();
$table->timestamp('created_at')->default(DB::raw('CURRENT_TIMESTAMP'));
$table->timestamp('updated_at')->default(DB::raw('CURRENT_TIMESTAMP'));
$table->timestamp('deleted_at')->nullable();
Copy code

category_translation table;

$table->id();
$table->integer('category_id')->index()->unsigned();
$table->integer('language_id')->index()->unsigned();
$table->string('title');
Copy code

Example category structure;

- Programming (top category)

-- Web
---- Php
---- Ruby
---- Perl

-- Mobile
---- Objective C
---- Java
---- Swift
Copy code

My purpose is to delete all sub + sub + sub categories when I delete a parent category. I need to get recursively all the sub categories by giving a parent ID to delete all of them.

I made some searches to find a way but nothing was helpful for me.

I hope I can find a solution here.

Thank you.

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.