duansha6410
2015-07-02 17:30
浏览 38
已采纳

Laravel 5:如何使用Eloquent查询数据透视表

Is there a way to use Eloquent to query a pivot table without having a model for that pivot table?

Situation: a user can own multiple businesses, and a business can be owned by multiple users. I have the following tables to deal with the many-to-many relationship.

| users     | businesses  | business_user |
-------------------------------------------
| id        | id          | business_id   |
| name      | name        | user_id       |
| created_at| created_at  | created_at    |
| updated_at| updated_at  | updated_at    |

My User.php model

public function businesses()
{
    return $this->belongsToMany('App\Business')->withTimestamps();
}

My Business.php model

public function users()
{
    return $this->belongsToMany('App\User')->withTimestamps();
}

1- In my controller, i'm trying to query the business_user (pivot) table to count the number of businesses the Auth user Id has.

select count(*) from business_user where user_id = Auth::user()->id() ;

2- I'm trying to query the business_user (pivot) table to get the business name for each row found in table business_user for that user id.

select business_user.business_id, businesses.name 
  from business_user 
  join businesses 
    on business_user.business_id = businesses.id
 where business_user.user_id     = Auth::user()->id() ;

I would like to query the pivot table with Eloquent, but I can't get the syntax right. Do I need a model for that business_user table?

Do some of you prefer not using Eloquent at all?

Thanks cv

  • 写回答
  • 好问题 提建议
  • 追加酬金
  • 关注问题
  • 收藏
  • 邀请回答

1条回答 默认 最新

  • dqhbuwrwq692118284 2015-07-02 17:36
    已采纳

    You don't need Model for a Pivot table. Things you are asking for are pretty straight forward.

    Number of businesses the current logged in User has

    echo \Auth::user()->businesses->count();
    

    name of each business for current User

    foreach(\Auth::user()->businesses as $business){
      echo $business->name;
    }
    
    评论
    解决 无用
    打赏 举报

相关推荐 更多相似问题