Laravel nested relationships

by 
return Event::with('city.companies.persons')->get();

If you only want to select certain fields from the persons table, use this:

return Event::with(['city.companies.persons' => function ($query) {
    $query->select('id', '...');
}])->get();

More Related Contents:

  1. Laravel one to many relation with a one to one relation
  2. How to use multiple databases in Laravel
  3. PDOException SQLSTATE[HY000] [2002] No such file or directory
  4. Using PHP data in MySQL [closed]
  5. Automated or regular backup of mysql data
  6. strange character encoding of stored data , old script is showing them fine new one doesn’t
  7. How to do this in Laravel, subquery where in
  8. PDO mysql: How to know if insert was successful
  9. How to loop through a mysql result set
  10. How to successfully rewrite old mysql-php code with deprecated mysql_* functions?
  11. Fetching single row, single column with PDO
  12. Is there any way to check the performance of mysql Indexing
  13. IP address storing in MySQL database using PHP [duplicate]
  14. Proper Repository Pattern Design in PHP?
  15. “No such file or directory” or “No such host is known” when running migrations
  16. Laravel 5.4 on PHP 7.0: PDO Exception – Could not find driver (MySQL)
  17. Using LIKE in bindParam for a MySQL PDO Query [duplicate]
  18. Laravel Eloquent get results grouped by days
  19. php artisan migrate throwing [PDO Exception] Could not find driver – Using Laravel
  20. Change name of Laravel’s created_at and updated_at
  21. How do I get database column names in Laravel?
  22. Laravel Change Connection Dynamically
  23. mysqli – fetch_Array error call to a member function fetch_array() on a non-object mysqli [duplicate]
  24. Eloquent many-to-many-to-many – how to load distant relation easily
  25. Mysql InnoDB engine in Laravel
  26. PHP Laravel: No connection could be made because the target machine actively refused it
  27. Auto Increment skipping numbers?
  28. How to get last inserted id from table MySQL [duplicate]
  29. Check if laravel model got saved or query got executed
  30. find in set in laravel ? example

Leave a Comment