Laravel hasOne through a pivot table

Question

So I have 2 models, User & Profile, the relationship is set up as follows:

    /**
     * User belongs to many Profile
     *
     * @return \Illuminate\Database\Eloquent\Relations\belongsToMany
     */
    public function profiles()
    {
        return $this->belongsToMany('App\Models\Profile', 'user_profiles');
    }

I have 3 tables, users, profiles & user_profiles (the pivot table)

I have a column in my users table called active_profile which gets populated with a profile id.

How can I set up the relationship so that I can call something like the following:

$user->active_profile

So that it will return all the profile information for the id set in active_profile?

If the column `active_profile` on `users` table references `id` on `profiles` table - why do you need a pivot to get an active profle model? — Edmund Sulzanok, Jan 18 '23 at 10:38

Clément Baconnier · Answer 1 · 2019-12-12T11:47:56.477

On Laravel 5.8, since I wanted to use it with eager loading I used this package: https://github.com/staudenmeir/eloquent-has-many-deep

This was my scenario
A user can be tagged on many photo and a photo can have many users tagged on. I wanted to have a relationship to get the latest photo the user has been tagged on.

I think my scenario can also be applied to any many-to-many relationship

I did the pivot model UserPhoto

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Relations\Pivot;

class UserPhoto extends Pivot
{

    public function user()
    {
        return $this->belongsTo(User::class);
    }

    public function photo()
    {
        return $this->belongsTo(Photo::class);
    }

}

And then on my User model using staudenmeir's package:

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;
use Staudenmeir\EloquentHasManyDeep\HasRelationships;

class User extends Model
{
    use HasRelationships;

    public function photos()
    {
        return $this->belongsToMany(Photo::class);
    }

    public function latestPhoto()
    {
        return $this->hasOneDeep(Photo::class, [UserPhoto::class])
            ->latest();
    }
}

Then I can easily do something like this:

User::with('latestPhoto')->get() and $user->latestPhoto

Edit: In an another question, someone asked the same without using a package. I also provided an answer that will do the same result.

But after digging deeper, from both answers, you may avoid the n+1 query, you will still hydrate all the photos from your requested users. I don't think it's possible to avoid one or the other approach. The cache could be an answer though.

Amazing. Thank you! This might be the most under-rated package in the lara echo system. — Tarek Adam, Dec 07 '19 at 01:20
@scott This is a method added with the package I have mentionned at the top of the answer. See : https://github.com/staudenmeir/eloquent-has-many-deep#hasonedeep — Clément Baconnier, Oct 01 '21 at 18:15

score 3 · Answer 2 · answered Feb 05 '17 at 10:09

3

I could be wrong but why not just use a belongsTo relationship?

public function active_profile()
{
    return $this->belongsTo('App\Models\Profile', 'active_profile');
}

Hope this helps!

answered Feb 05 '17 at 10:09

Rwd

34,180
6
64
78

score 0 · Answer 3 · answered Feb 03 '17 at 22:11

0

You should be able to grab the resource using find

$user->profiles()->find($user->active_profile);

answered Feb 03 '17 at 22:11

Jeff Puckett

37,464
17
118
167

Although this works, I was hoping for a more elegant solution, preferably using eloquent relationships. I will be implementing your solution for the time being but would like to leave the question open to other options for a while. – ChrisBratherton Feb 03 '17 at 22:14

score 0 · Accepted Answer · answered Feb 03 '17 at 22:29

0

You can add a method into your User model like this :

public function active_profile ()
{
   return $this->profiles()
          ->find($this->active_profile);
}

and then you can call the method as $user->active_profile();

answered Feb 03 '17 at 22:29

Amr Aly

3,871
2
16
33

score 0 · Answer 5 · edited Jul 30 '18 at 16:54

You could add extra field in pivot table, for example active = enum(y, n), then set unique key (user_id, active) and then use wherePivotmethod in user model:

public function profiles()
{
  return $this->belongsToMany('App\Models\Profile', 'user_profiles');
}

public function activeProfile()
{
  return $this->belongsToMany('App\Models\Profile', 'user_profiles')->wherePivot('active', 'y');
}

It requires DB refactoring though.

Laravel hasOne through a pivot table

5 Answers5

Linked