vendredi 18 décembre 2020

Laravel many to many relationship need to execute a query to get users list where role_id = 5

I have the below tables

  1. users : id | name
  2. projects : id | name
  3. user_project : id | user_id | project_id

My Models contains

  1. User.php

    public function projects() { return $this->belongsToMany(Project::class); }

  2. Project.php

    public function users() { return $this->belongsToMany(User::class); }

In my controller file, I want to get a list of users using the User model whose role_id is 5.

Something like below

User::query()->roles(5);

*Help will be appreciated



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire