Eloquent many-to-many-to-many – how to load distant relation easily

by

This is how you can do it:

User::where('id', $id)->with(['groups.permissions' => function ($q) use (&$permissions) {
     $permissions = $q->get()->unique();
}])->first();

// then
$permissions; // collection of unique permissions of the user with id = $id

More Related Contents:

  1. Laravel one to many relation with a one to one relation
  2. How to do this in Laravel, subquery where in
  3. Laravel OrderBy relationship count
  4. Laravel 5.2 – Use a String as a Custom Primary Key for Eloquent Table becomes 0
  5. Laravel $q->where() between dates
  6. Eloquent groupBy make “SQLSTATE[42000]” with valid SQL query in Laravel 5.3
  7. How do I store a custom user selected CSS template style (like wordpress visual editor)? [closed]
  8. Laravel – only a zero is saved to the database
  9. How to use multiple databases in Laravel
  10. How do I get the query builder to output its raw SQL query as a string?
  11. Laravel Check If Related Model Exists
  12. Laravel migration: unique key is too long, even if specified
  13. Laravel: PDOException: could not find driver
  14. Laravel Eloquent select all rows with max created_at
  15. Laravel Model with Two Primary Keys update [duplicate]
  16. Laravel: connect to databases dynamically
  17. Laravel eager loading with limit
  18. How to bind parameters to a raw DB query in Laravel that’s used on a model?
  19. Laravel Eloquent: How to order results of related models?
  20. SQLSTATE[HY000] [2002] A connection attempt failed.. – When attempting to connect from Local to remote server
  21. How to set a default attribute value for a Laravel / Eloquent model?
  22. Laravel Migration table already exists, but I want to add new not the older
  23. Laravel – Database, Table and Column Naming Conventions?
  24. Order By before Group By using Eloquent (Laravel)
  25. How to Merge Two Eloquent Collections?
  26. Difference between Eloquent\Model::get() and all()
  27. Laravel Eloquent get results grouped by days
  28. Laravel 4.1: How to paginate eloquent eager relationship?
  29. How to create a database-driven multi-level navigation menu using Laravel
  30. Laravel Eloquent update just if changes have been made

Leave a Comment