douba9654 2017-10-05 18:07
浏览 34
已采纳

与同一表Laravel 5具有相同外键的关系

I am building a referral system, the table User is referred by another, for example:

User table:

id

name

Referrals table:

id

referred_by (user_id)

refers_to (user_id)

Same foreign key to the same table. Which are the relationships between User table and Referrals?

  • 写回答

2条回答 默认 最新

  • dpc57092 2017-10-05 18:18
    关注

    I am assuming your user model is App\User and your Referral model is App\Referral:

    If you want to get, via your user, who they have referred you can do in App\User:

    function  referredBy() {
        return $this->hasMany('App\Referral', 'referred_by');
    }
    

    If you want to get, via your user, who they were referred by:

    function referredTo() {
        return $this->hasMany('App\Referral', 'refers_to');
    }   
    

    Anywhere you have a $user object, you can get a list of all other referenced users by $user->referredTo() or $user->referredBy() The Eloquent models allow you to create many different style relations with different key names.

    Reference: https://laravel.com/docs/5.5/eloquent-relationships#introduction

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥20 数据排序,可选择排序方向
  • ¥15 修改一下代码,考虑进程到达时间不同的情况
  • ¥15 华为nova10pro ,关闭热动热点用量记录
  • ¥15 帮我看看这是个啥题,带解题过程和结果,条件如下FCF = 290471.33 g1 = 15% r = 8% g2 = 4% n = 5
  • ¥15 edem模拟颗粒不显示或者生成失败
  • ¥15 Python代码编写
  • ¥15 php 将rtmp协议转hls协议,无法播放
  • ¥20 python代码编写
  • ¥20 使用MPI广播数据遇到阻塞
  • ¥15 TinyMCE如何去掉自动弹出的“链接…”工具?