使用多对多关系的透视表创建一对多关系

Question

用户表结构：用户

id、名称、用户名、密码、创建时间、更新时间

文章表结构：文章

id、标题、内容、创建时间、更新时间

关系表：文章\用户

id、文章id、用户id处于活动状态、创建时间、更新时间

标签

id、名称、用户id、创建时间、更新时间

透视表项目用户与标记的关系。表：文章\用户\标签

标签号，物品号，用户号

class User extends Model
{
    protected $fillable = ['name','username','password'];

    public function articles()
    {
        return $this->belongsToMany('App\Article')->withPivot('is_active')->withTimestamps();
    }

    public function tags()
    {
        return $this->hasMany('App\Tag');
    }
}

class Article extends Model
{
    protected $fillable = ['title','content'];

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

        public function tags()
    {
        return $this->belongsToMany('App\Tag');
    }       
}

class Tag extends Model
{
    protected $fillable = ['title','content'];

    public function articles()
    {
        return $this->belongsToMany('App\Article');
    }

    public function user()
    {
        return $this->belongsTo('App\User');
    }
}

我想连接这些表，以便可以像这样或类似的格式访问

$user->articles()->first()->tags;

并且应该能够创建/更新smth，就像这样

$user->articles()->first()->create(['title'=>'testing','content'=>'content'])->attach(['tag_id_1','tag_id_2','tag_id_3']);

非常感谢您的帮助

Answer 1

试试这个：

class User extends Model
{
    protected $fillable = ['name','username','password'];

    public function articles()
    {
        return $this->hasMany('App\ArticleUser')->with('article');
    }

    public function tags()
    {
        return $this->hasMany('App\Tag');
    }
}

class ArticleUser extends Model
{
    public funciton article()
    {
        return $this->belongsTo('App\Article');
    }

    public function user()
    {
        return $this->belongsTo('App\User');
    }

    public function tags()
    {
        return $this->belongsToMany('App\Tag');
    }
}

class Article extends Model
{
    protected $fillable = ['title','content'];
}

class Tag extends Model
{
    protected $fillable = ['title','content'];

    public function articles()
    {
        return $this->belongsToMany('App\ArticleUser')->with('article');
    }

    public function user()
    {
        return $this->belongsTo('App\User');
    }
}