Thinkphp对对多关联查询

admin

Thinkphp对对多关联查询

1. <?php
   
2. namespace app\model;
   
3. use think\Model;
   
4. class role extends Model
   
5. {
   
6. }

复制代码

1. <?php
   
2. namespace app\model;
   
3. use think\model\Pivot;
   
4. class access extends Pivot
   
5. {
   
6. }

复制代码

1. <?php
   
2. namespace app\model;
   
3. use think\Model;
   
4. class User extends Model
   
5. {
   
6.     public  function roles(){
   
7.         return $this->belongsToMany(Role::class,Access::class,'role_id','user_id');
   
8.     }
   
9. }

复制代码

1. <?php
   
2. namespace app\controller;
   
3. use app\model\User as UserModel;
   
4. class Grade
   
5. {
   
6.     public function index()
   
7.     {
   
8.         $user = UserModel::find(19);
   
9.         $roles =$user->roles;
   
10.         return json($roles);
    
11.     }
    
12. }

复制代码

thinkphp教程