PHPackages kingmaker/laravel-many-to-many-self-relationship - 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. kingmaker/laravel-many-to-many-self-relationship ActiveLibrary[Database & ORM](/categories/database) kingmaker/laravel-many-to-many-self-relationship ================================================ Laravel Many to Many Relationship on the same Model through a pivot table providing two-way association. 2.1.8(3mo ago)1979.7k↑10.9%2[1 issues](https://github.com/kingmaker-agm/laravel-many-to-many-self/issues)MITPHPPHP ^7.2|^8.0CI passing Since May 28Pushed 3mo ago1 watchersCompare [ Source](https://github.com/kingmaker-agm/laravel-many-to-many-self)[ Packagist](https://packagist.org/packages/kingmaker/laravel-many-to-many-self-relationship)[ Docs](https://github.com/kingmaker-agm/laravel-many-to-many-self)[ RSS](/packages/kingmaker-laravel-many-to-many-self-relationship/feed)WikiDiscussions 2.1+ Synced 3d ago READMEChangelogDependencies (6)Versions (22)Used By (0) Laravel Many to Many Self Relationship ====================================== [](#laravel-many-to-many-self-relationship) [![Version](https://camo.githubusercontent.com/d699b2ead3a184cc99170648066a2fc23f814e85ec98c052efa4d9836f27b70f/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f56657273696f6e2d322e312d627269676874677265656e)](https://packagist.org/packages/kingmaker/laravel-many-to-many-self-relationship)[![Packagist Downloads](https://camo.githubusercontent.com/dcb70d7fda30f23a1bf236c787c595931fbfd8c6afed540e0877e431a25c90b0/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f646d2f6b696e676d616b65722f6c61726176656c2d6d616e792d746f2d6d616e792d73656c662d72656c6174696f6e73686970)](https://camo.githubusercontent.com/dcb70d7fda30f23a1bf236c787c595931fbfd8c6afed540e0877e431a25c90b0/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f646d2f6b696e676d616b65722f6c61726176656c2d6d616e792d746f2d6d616e792d73656c662d72656c6174696f6e73686970)[![Laravel](https://camo.githubusercontent.com/ab86c283577907b4b26cb0b890a7cb955acc67132051c3b51fef96a29705392f/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f4c61726176656c2d362532422d666636393462)](https://laravel.com/)[![Run PHPUnit Tests](https://github.com/kingmaker-agm/laravel-many-to-many-self/actions/workflows/run-tests.yml/badge.svg)](https://github.com/kingmaker-agm/laravel-many-to-many-self/actions/workflows/run-tests.yml)[![License](https://camo.githubusercontent.com/d6bc2b26794002c24d023acaab01b6dbb953c57ab9cb80ba5b8aa2f2bd5de99a/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f4c6963656e73652d4d49542d626c7565)](https://opensource.org/licenses/MIT) This package includes an extension to the `belongsToMany` Relationship of the Laravel allowing **two-way association** between the same model with a single Entry on the pivot table. Installation ------------ [](#installation) The package can be installed via Composer. ``` composer require kingmaker/laravel-many-to-many-self-relationship ``` Version ------- [](#version) This package is available on specific Laravel versions. Package VersionLaravel Version1.x6.20+ or 7.29+2.0.x8.17 - 8.342.1+8.35+ or 9+Usage ----- [](#usage) Include the `HasBelongsToManySelfRelation` trait in the **Model class** and define the relation method as follows: ``` use Illuminate\Database\Eloquent\Model; use Kingmaker\Illuminate\Eloquent\Relations\HasBelongsToManySelfRelation; class Post extends Model { use HasBelongsToManySelfRelation; public function relatedPosts() { return $this->belongsToManySelf('related_posts', 'post1', 'post2'); } } ``` It is that simple and has all the Methods available on the `belongsToMany()`. The Related Posts can be accessed like any normal relation. ``` $post = Post::first(); $post->relatedPosts; // returns Collection of Related Posts ``` > This is an extension over the native `BelongsToMany` class provided by the Eloquent. Example ------- [](#example) Consider there are 'posts' table and 'related\_posts' table. The Post represent Post in the blog and it can have related posts similar to them. ``` posts: | id | title | body | +----+-------+------+ | 1 | a | ... | | 2 | b | ... | | 3 | c | ... | | 4 | d | ... | +----+-------+------+ related_posts: | id | post1 | post2 | +----+-------+-------+ | 1 | 1 | 3 | | 2 | 1 | 4 | | 3 | 2 | 1 | | 4 | 2 | 3 | | 5 | 3 | 4 | | 6 | 4 | 2 | +----+-------+-------+ ``` The `belongsToManySelf` relation provides **two-way association** when calling the Relation. ``` Post::find(1)->relatedPosts; // returns Posts with id 2, 3, 4 Post::find(2)->relatedPosts; // returns Posts with id 1, 3, 4 Post::find(3)->relatedPosts; // returns Posts with id 1, 2, 4 Post::find(4)->relatedPosts; // returns Posts with id 1, 2, 3 ``` Caution ------- [](#caution) There is a possibility for the returning of *duplicate related object*if the entities are related by 2rows on the Pivot table. Use Cases --------- [](#use-cases) This **two-way associated** Many-to-Many relationship can be used in few peculiar situations. This relation doesn't suit all the Scenarios. ### a) Related Posts / Products [](#a-related-posts--products) Consider a blog or shopping website, where we have *post / product* related to each other. When the related Entity is matched via `BelongsToMany` relationship, the association of one Post/Product as related to the other post/product, on fetching the *relatedPost* or *relatedProduct* from the first Object will yield the second, but the inverse is not true (*ie, getting first post/product as related post/product from the second*) ### b) Friend list in social media [](#b-friend-list-in-social-media) In Social Media, the concept of Users being friended to one another can be easily achieved using this relation (not followers & following, just mutual friends). Once a Users add another User as friends, we can attach the User and doesn't need to care about the attachment of reverse while using this relationship. > **Note**: The Concept of *followers* and *following* has to use the Laravel's `BelongsToMany` relation. This relation is for *friends* like in Facebook. ### c) Messages in a Chat [](#c-messages-in-a-chat) The Message in a Chat application, where a message is directed from a User to another User. This relation lets you retrieve all the Users that have messaged a particular User. > **Note**: There may be possibility of duplicates in this case API Reference ------------- [](#api-reference) The trait `HasBelongsToManySelfRelation` adds the method `belongsToManySelf` to your Model. ``` /** * create the BelongsToManySelf relation on the same Model via a pivot table * * @param string $table Pivot table name * @param string $pivotKey1 Pivot table foreign key 1 * @param string $pivotKey2 Pivot table foreign key 2 * @param string|null $relatedKey Related key on the parent table * @param string|null $relation Relation name * @return BelongsToManySelf */ public function belongsToManySelf(string $table, string $pivotKey1, string $pivotKey2, $relatedKey = null, $relation = null) ``` The `BelongsToManySelf` is a concrete/child/sub-class of the Eloquent `BelongsToMany` class. So, All the methods available on the `BelongsToMany` is also available on this Relation. Known Issues ------------ [](#known-issues) The following Issues / Problems were found in this package or the underlying Database Engine. - the `has` and `whereHas` constraint will not work in **MySQL < v8.0.14** Tips ---- [](#tips) - To improve the performance of the relation, create **two Pivot Table indexes** such as `(pivot_key1, pivot_key2)` and `(pivot_key2, pivot_key1)` Contributing ------------ [](#contributing) Contributions are always welcome! Feel free to open Issues and submit **Pull Requests** You can also support me [!["Buy Me A Coffee"](https://camo.githubusercontent.com/9f44ce2dc3b3eecdd02598900866ffc518801df1932849703dae1e5ce5031070/68747470733a2f2f7777772e6275796d6561636f666665652e636f6d2f6173736574732f696d672f637573746f6d5f696d616765732f6f72616e67655f696d672e706e67)](https://www.buymeacoffee.com/bgpratheep) ### Health Score 54 — FairBetter than 96% of packages Maintenance81 Actively maintained with recent releases Popularity41 Moderate usage in the ecosystem Community13 Small or concentrated contributor base Maturity66 Established project with proven stability Bus Factor1 Top contributor holds 93.2% 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. ### Release Activity Cadence Every ~118 days Recently: every ~72 days Total 16 Last Release 90d ago Major Versions 1.0.0 → 2.1.02021-05-28 1.x-dev → 2.1.22022-06-21 ### Community Maintainers ![](https://www.gravatar.com/avatar/a73fdca69f0fe759b6916d6db0cea5f124b3fc5e3199e0c472610388dda6d4e0?d=identicon)[kingmaker](/maintainers/kingmaker) --- Top Contributors [![kingmaker-agm](https://avatars.githubusercontent.com/u/23194965?v=4)](https://github.com/kingmaker-agm "kingmaker-agm (68 commits)")[![Bloemendaal](https://avatars.githubusercontent.com/u/1348606?v=4)](https://github.com/Bloemendaal "Bloemendaal (3 commits)")[![blite](https://avatars.githubusercontent.com/u/442226?v=4)](https://github.com/blite "blite (1 commits)")[![tobyzerner](https://avatars.githubusercontent.com/u/128862?v=4)](https://github.com/tobyzerner "tobyzerner (1 commits)") --- Tags laravelmany to manyrelationrelationshipbelongs-to-manymany-to-many-selfbelongs-to-many-selftwo way association ### Embed Badge ![Health badge](/badges/kingmaker-laravel-many-to-many-self-relationship/health.svg) ``` [![Health](https://phpackages.com/badges/kingmaker-laravel-many-to-many-self-relationship/health.svg)](https://phpackages.com/packages/kingmaker-laravel-many-to-many-self-relationship) ``` ### Alternatives [mongodb/laravel-mongodb A MongoDB based Eloquent model and Query builder for Laravel 7.1k8.4M96](/packages/mongodb-laravel-mongodb)[kirschbaum-development/eloquent-power-joins The Laravel magic applied to joins. 1.6k32.6M46](/packages/kirschbaum-development-eloquent-power-joins)[yajra/laravel-oci8 Oracle DB driver for Laravel via OCI8 8793.2M25](/packages/yajra-laravel-oci8)[awobaz/compoships Laravel relationships with support for composite/multiple keys 1.2k11.7M46](/packages/awobaz-compoships)[bavix/laravel-wallet It's easy to work with a virtual wallet. 1.3k1.3M19](/packages/bavix-laravel-wallet)[glushkovds/phpclickhouse-laravel Adapter of the most popular library https://github.com/smi2/phpClickHouse to Laravel 2051.5M2](/packages/glushkovds-phpclickhouse-laravel) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)