Laravel Recursive Relationships

by

This is how you can use recursive relations:

public function childrenAccounts()
{
    return $this->hasMany('Account', 'act_parent', 'act_id');
}

public function allChildrenAccounts()
{
    return $this->childrenAccounts()->with('allChildrenAccounts');
}

Then:

$account = Account::with('allChildrenAccounts')->first();

$account->allChildrenAccounts; // collection of recursively loaded children
// each of them having the same collection of children:
$account->allChildrenAccounts->first()->allChildrenAccounts; // .. and so on

This way you save a lot of queries. This will execute 1 query per each nesting level + 1 additional query.

I can’t guarantee it will be efficient for your data, you need to test it definitely.

This is for childless accounts:

public function scopeChildless($q)
{
   $q->has('childrenAccounts', '=', 0);
}

then:

$childlessAccounts = Account::childless()->get();

More Related Contents:

  1. Laravel one to many relation with a one to one relation
  2. How to Create Multiple Where Clause Query Using Laravel Eloquent?
  3. Get the Last Inserted Id Using Laravel Eloquent
  4. Bulk Insertion in Laravel using eloquent ORM
  5. How to insert multiple rows from a single query using eloquent/fluent
  6. Laravel – Eloquent or Fluent random row
  7. Add a custom attribute to a Laravel / Eloquent model on load?
  8. Creating and Update Laravel Eloquent
  9. Laravel, sync() – how to sync an array and also pass additional pivot fields?
  10. How to sort a Laravel query builder result by multiple columns?
  11. How to alias a table in Laravel Eloquent queries (or using Query Builder)?
  12. Laravel Eloquent Sum of relation’s column
  13. What does “Mass Assignment” mean in Laravel?
  14. Laravel 5.2 – Use a String as a Custom Primary Key for Eloquent Table becomes 0
  15. Laravel 4: how to “order by” using Eloquent ORM [duplicate]
  16. How to exclude certains columns while using eloquent
  17. How to alias the name of a column in Eloquent
  18. Laravel $q->where() between dates
  19. How to Make Laravel Eloquent “IN” Query?
  20. Laravel Eloquent – Attach vs Sync
  21. Update without touching timestamps (Laravel)
  22. laravel collection to array
  23. Laravel Eloquent sort by relation table column
  24. Eloquent Parent-Child relationship on same model
  25. Natural ORDER in Laravel Eloquent ORM
  26. How can I query raw via Eloquent?
  27. A __construct on an Eloquent Laravel Model
  28. How to get last insert id in Eloquent ORM laravel
  29. Eloquent groupBy make “SQLSTATE[42000]” with valid SQL query in Laravel 5.3
  30. Laravel Eloquent update just if changes have been made

Leave a Comment