dsunj08246 2018-05-15 11:01
浏览 47
已采纳

Laravel 5.2 - 通过多个表加入

I have the following tables:

User
    id

Suggestions_For
    id
    user_id
    suggested_account

Suggestions
    id

(User.id = Suggestions_For.user_id)
(Suggestions_For.suggested_account = Suggestions.id)

If I want to get all suggestions for user like this: $user->suggestions()->count()

how can I do it? Is there way to define a relationship in my model that goes through multiple pivot tables to join a user to suggestions?

I've tried with:

public function suggestions()
{
    return $this->hasManyThrough('App\Suggestions', 'App\Suggestions_For', 'suggested_account', 'id');
}

but does not seems to work

  • 写回答

1条回答 默认 最新

  • dougou8573 2018-05-15 11:06
    关注

    You can define your relationship as ManyToMany using pivot table suggestions_for as

    User Model

    public function suggestions()
    {
        return $this->belongsToMany(Suggestions::class, 'suggestions_for', 'user_id')
    }
    

    Suggestions Model

    public function users()
    {
        return $this->belongsToMany(User::class, 'suggestions_for', 'suggested_account ')
    }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?