PHPackages                             minh164/elonest - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Database & ORM](/categories/database)
4. /
5. minh164/elonest

ActiveProject[Database & ORM](/categories/database)

minh164/elonest
===============

Nested set model for Eloquent in Laravel package.

823PHP

Since May 9Pushed 2y ago1 watchersCompare

[ Source](https://github.com/minh164/elonest)[ Packagist](https://packagist.org/packages/minh164/elonest)[ RSS](/packages/minh164-elonest/feed)WikiDiscussions master Synced today

READMEChangelogDependenciesVersions (2)Used By (0)

### **What is Nested set model?**

[](#what-is-nested-set-model)

The nested set model is a technique for representing nested set collections (also known as trees or hierarchies) in relational databases (as Wikipedia).

[![img.png](images/img.png)](images/img.png)

Above image is a collection with multiple level nodes, "Devices" node parent has multiple node children which are "Phone", "Laptop", and each node child has multiple children of children... With a node will have right and left values. Yeah, this is nested set model!

### **Why should we use Nested set model?**

[](#why-should-we-use-nested-set-model)

As usually, we use recursion technique to get each levels. Ex: with above devices list, to get all children of "Devices" node, we must recursively loop each node to find its children, let count total of queries:

1. *Find children of "Devices" ("Phone", "Laptop").*
2. *Find children of "Phone" ("Apple", "SamSung").*
3. *Find children of "Apple" ("Iphone", "Iphone Pro Max").*
4. *Find children of "SamSung" ("Note").*
5. *Find children of "Note".*
6. *Find children of "Laptop" .*

Six queries to get children of Devices, it's seem not a big problem? But we imagine increase number of node levels up to 100 1000 or 10.000,... I can't count query total we need :D.

Okay, we try change to use nested set model, that big problem will be solved by this technique. Let count queries again:

1. *Find all node children have Left > 1 and Right < 22.*
2. *End. Don't need step 2 :D*

We only use ONE query to solve it, instead of too many queries with recursion. 1 is Left value and 22 is Right value of "Devices" node, nested set model will use the pair to calculate everything by algorithm.

### **How to use:**

[](#how-to-use)

Extend `Minh164\EloNest\NestableModel` class for the model we need apply nested set model:

[![img_1.png](images/img_1.png)](images/img_1.png)

Next, you make a migration to create some necessary columns for table, add these lines into new created migration file:

```
$table->bigInteger('lft')->index();
$table->bigInteger('rgt')->index();
$table->unsignedMediumInteger('depth')->default(0);
$table->unsignedMediumInteger('parent_id')->default(0)->index();
$table->unsignedMediumInteger('original_number')->comment("Identifier number to determine folders belong together")->index();

```

### **CRUD methods:**

[](#crud-methods)

Likes base Eloquent Model has Eloquent Builder class, NestableModel also has NodeBuilder class, we will use some methods in this class to implement CRUD logic.

---

### *Create node:*

[](#create-node)

We use `createNode` method to create new node, this method receives two parameters:

1. `data`: array info we need for new node.
2. `parentId`: Node parent ID which new node will be child. If null, new node will be a new root node.

[![img_2.png](images/img_2.png)](images/img_2.png)

[![img_3.png](images/img_3.png)](images/img_3.png)

---

### **Delete node:**

[](#delete-node)

We use `deleteNodes` method:

[![img_4.png](images/img_4.png)](images/img_4.png)

---

### **Move node:**

[](#move-node)

You use `moveNode` method to change position of node.

***WARNING: this method has just only update one record, I will update for multiple records later.***

[![img_6.png](images/img_6.png)](images/img_6.png)

Method receives two parameters:

1. *previous*: value at left side of position will be need move
2. *next*: value at right side of position will be need move

NOTICE: *previous* and *next* values IS NOT *left* and *right* values of node, we should view this image:

[![img_5.png](images/img_5.png)](images/img_5.png)

If we want move "Apple" to before "HP", then *previous* and *next* values are passed to moveNode: **14** and **15**.

---

### **Get nodes:**

[](#get-nodes)

Instead of using `->get()` method to get list, we will use `->getNodes()` method to return `NestedCollection` object, this will help you process complicated nested logic:

***WARNING: for get one record (same as `->first()`) will be updated later.***

[![img_7.png](images/img_7.png)](images/img_7.png)

Likely `with` method to get relations, we have `withNodes` to get relations for ALL nested nodes, and also handle by **Eager Load**!

[![img_8.png](images/img_8.png)](images/img_8.png)

In `NestableModel` has implemented some relations for your Model use it:

[![img_9.png](images/img_9.png)](images/img_9.png)

We can use both `with` and `withNodes`, but `with` only get relations for parent nodes not for nested children:

[![img.png](images/img11.png)](images/img11.png)

And yeah! we also can create a **custom node relation** by extends and override some methods in abstract `Minh164\EloNest\Relations\NodeRelation` class:

[![img_10.png](images/img_10.png)](images/img_10.png)

Updating.....

###  Health Score

17

—

LowBetter than 6% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity12

Limited adoption so far

Community9

Small or concentrated contributor base

Maturity24

Early-stage or recently created project

 Bus Factor1

Top contributor holds 81.3% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

### Community

Maintainers

![](https://www.gravatar.com/avatar/76a9ce9b6e4966a7e21337da9e47cbea3d9815a3f8cc929da9d6634454652198?d=identicon)[minh164](/maintainers/minh164)

---

Top Contributors

[![minh164](https://avatars.githubusercontent.com/u/30765881?v=4)](https://github.com/minh164 "minh164 (39 commits)")[![minhmp](https://avatars.githubusercontent.com/u/99628578?v=4)](https://github.com/minhmp "minhmp (9 commits)")

### Embed Badge

![Health badge](/badges/minh164-elonest/health.svg)

```
[![Health](https://phpackages.com/badges/minh164-elonest/health.svg)](https://phpackages.com/packages/minh164-elonest)
```

###  Alternatives

[jdorn/sql-formatter

a PHP SQL highlighting library

3.9k117.2M118](/packages/jdorn-sql-formatter)[propel/propel1

Propel is an open-source Object-Relational Mapping (ORM) for PHP5.

8351.6M87](/packages/propel-propel1)[jfelder/oracledb

Oracle DB driver for Laravel

11518.4k](/packages/jfelder-oracledb)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)