php - 如何查询 Laravel Eloquent

Question

我是 Laravel 的新手。我对laravel关系有疑问。你们能帮帮我吗？

我有四张桌子：
1. Users
2. Teams
3. Games
4. Picks

Picks是我的中间表模型
1. id
2. user_id
3. team_id
4。game_id

用户类

class User extends Model
{
  public function picks()
  {
     return $this->hasMany('App\Models\Pick');
  }
}

团队班

class Team extends Model
{
  public function picks()
  {
    return $this->hasMany('App\Models\Pick');
  }
}

游戏课

class Game extends Model
{
   public function picks()
   {
     return $this->hasMany('App\Models\Pick');
   }
}

class Pick extends Model
{
    public function users()
    {
        return $this->belongsToMany('App\Models\User');
    }

    public function teams()
    {
        return $this->belongsToMany('App\Models\Team');
    }

    public function schedules()
    {
        return $this->belongsToMany('App\Models\Schedule');
    }
}

如何将此查询转换为雄辩的？

"SELECT * FROM `games` AS g LEFT JOIN `picks` as p ON p.game_id = g.id LEFT JOIN `users` as u ON u.id = p.user_id WHERE u.id = 1;"

我想通过用户 ID 选择游戏。

标签： phplaravel

Answer 1

你正试图跳过桌子。检查文档：

https://laravel.com/docs/5.8/eloquent-relationships#has-many-through