laravel 关联模型

最新推荐文章于 2024-01-24 18:04:05 发布

jilangyu123

最新推荐文章于 2024-01-24 18:04:05 发布

阅读量379

点赞数

分类专栏： laravel

本文链接：https://blog.csdn.net/jilangyu123/article/details/93663335

版权

laravel 专栏收录该内容

12 篇文章 0 订阅

订阅专栏

一对一

model中定义方法（user）
 public function getRole(){
        $data = $this->hasOne(Roles::class,"id（role中的id）","rolle_id(user中的)");
        return $data;
    }
    其他地方使用这个方法
    Users::with('getRole:id,name')->get(['name','role_id'])->toArray();
    //with里面对于role表而言，get对于users

一对多

class Roles extends Model
{
    //
    protected $table="role";
    public function getUser(){
        $data = $this->hasMany(Users::class,"role_id","id");
        return $data;
    }
}

Roles::with('getUser:id,name,role_id')->get(['name','id'])->where('id',1)->first()->toArray();

多对多

class Student extends Model
{
    //
    protected $table="student";
    public function getSource(){
        return $this->belongsToMany(Source::class,"stu_source","stu_id","source_id");
    }
}
Student::where(['id'=>1])->with("getSource:num,s_name,stu_id")->get(["id","name"])->first()->toArray();