Laravel 5 hasMany relationship on two columns

by

I don’t think it’s possible to do exactly what you are asking.

I think you should treat them as separate relationships and then create a new method on the model to retrieve a collection of both.

public function userRelations() {
    return $this->hasMany('App\UserRelation');
}

public function relatedUserRelations() {
    return $this->hasMany('App\UserRelation', 'related_user_id');
}

public function allUserRelations() {
    return $this->userRelations->merge($this->relatedUserRelations);
}

This way you still get the benefit of eager loading and relationship caching on the model. 

$cause = Cause::with('donations.user.userRelations', 
        'donations.user.relatedUserRelations')
    ->where('active', 1)->first();

$userRelations = $cause->donations[0]->user->allUserRelations();

More Related Contents:

  1. Laravel Check If Related Model Exists
  2. How can I convert many statement mysql to laravel eloquent?
  3. Laravel Model with Two Primary Keys update [duplicate]
  4. Laravel 5.2 – Use a String as a Custom Primary Key for Eloquent Table becomes 0
  5. Laravel Checking If a Record Exists
  6. Difference between Eloquent\Model::get() and all()
  7. Eloquent Parent-Child relationship on same model
  8. Eloquent groupBy make “SQLSTATE[42000]” with valid SQL query in Laravel 5.3
  9. Merge ‘with’ and ‘whereHas’ in Laravel 5
  10. Laravel combined OR AND Solution
  11. Property Property Property [title] does not exist on this collection instance does not exist on this collection instance does not exist on this collection instance
  12. Laravel 5 – How to access image uploaded in storage within View?
  13. How to do this in Laravel, subquery where in
  14. Laravel Eloquent Query Using WHERE with OR AND OR?
  15. Laravel update model with unique validation rule for attribute
  16. Eloquent ORM Code Hinting in PhpStorm
  17. Laravel: How to Get Current Route Name? (v5 … v7)
  18. Get the Query Executed in Laravel 3/4
  19. What does “Mass Assignment” mean in Laravel?
  20. Why do I have to run “composer dump-autoload” command to make migrations work in laravel?
  21. Laravel 5.4 on PHP 7.0: PDO Exception – Could not find driver (MySQL)
  22. How to create a subquery using Laravel Eloquent?
  23. How to set the default value of an attribute on a Laravel model [duplicate]
  24. Eloquent model mass update
  25. Login only if user is active using Laravel
  26. Eloquent many-to-many-to-many – how to load distant relation easily
  27. laravel 5 : Class ‘input’ not found
  28. Class ‘App\Http\Controllers\DB’ not found and I also cannot use a new Model
  29. Find or Create with Eloquent
  30. Laravel Many to many self referencing table only works one way

Leave a Comment