如何获取与注册相关的注册类型的名称和价格？(雄辩)

Question

当用户单击“支付”按钮时，他被重定向到像"http://proj.test/conference/2/conference-title/payment/registration/6“这样的支付页面，其中6是用户要支付的注册id，"2”是会议id，因此用户使用id "2“支付有关会议的注册。

在注册付款页面中应出现注册摘要。例如，如果用户在具有3种票证/注册类型、1种类型为"general“和2种类型为"plus”的会议上进行了注册，则应该出现一个摘要，如下所示：

Title of the conference (ex: Conference test)
Date of the conference

Registration Type   Quantity         Price     Subtotal
 general             1            0.00 €      0.00$
 plus                2            1.00 €      2.00$

因此，当用户单击“支付”按钮时，我有此路由：

Route::get('/conference/{id}/{slug?}/payment/registration/{regID}', [
    'uses' => 'PaymentController@showSummary',
    'as'   =>'conferences.showSummary'
]);

在showSummary()中，我已经得到了会议名称和日期：

public function showSummary($id = "", $slug = "", $regID){

    $registration = Registration::with([
        'conference' => function ($query) {
            $query->select('id', 'name', 'date');
        }
    ])->find($regID);       
}

怀疑:我的疑问是如何更改以下查询，以获取与注册相关的每种注册类型的名称和价格，以及获取数量，以便能够像上面的摘要那样显示一个摘要。

通过以下方式：

$registrationTypeDetails = Registration::with([
            'participants' => function ($query) {
                $query->select('id', 'registration_type_id', 'registration_id')->where('registration_id', $regID);
            }
        ])->find($regID);

        dd($registrationTypeDetails);

$registrationTypeDetails显示与注册相关的参与者：

Registration {#264 ▼
...
  #relations: array:1 [▼
    "participants" => Collection {#261 ▼
      #items: array:2 [▼
        0 => Participant {#269 ▼
          #fillable: array:4 [▶]
          ...
          #attributes: array:3 [▼
            "id" => 3
            "registration_type_id" => 2
            "registration_id" => 2
          ]
         ...
        }
        1 => Participant {#271 ▼
          #fillable: array:4 [▶]
          ....
          #attributes: array:3 [▼
            "id" => 4
            "registration_type_id" => 3
            "registration_id" => 2
          ]
         ....
        }
      ]
    }
  ]
}

因此，有了上面的查询，就可以到达与注册相关的参与者的registration_type_id，因此应该可以获得关于每种注册类型的信息，但我不知道如何更改查询以实现这一点。

你知道如何做到这一点吗？

问题的相关表格结构：

Registration: id, status, conference_id, main_participant_id   
    (main_participant_id is the id of the user that did the regitration)

Registration Types: id, name, price, conference_id

Conference: id, name, date, organizer_id

Participant: id, registration_id, registration_type_id, name, surname

这一问题的相关模式：

用户模型：

 class User extends Authenticatable
    {
        public function conferences(){
            return $this->hasMany('App\Conference', 'organizer_id');
        }
        public function registrations(){
            return $this->hasMany('App\Registration','main_participant_id');
        }
    }

会议模式：

class Conference extends Model
{
    public function organizer(){
        return $this->belongsTo('App\User', 'organizer_id');
    }
    public function registrationTypes(){
        return $this->hasMany('App\RegistrationType', 'conference_id');
    }
    public function registrations(){
        return $this->hasMany('App\Registration', 'conference_id');
    }
}

登记类型模型：

class RegistrationType extends Model
{
    public function conference(){
        return $this->belongsTo('App\Conference');
    }

    // a registration can have many participants
    public function participants(){
       return $this->hasMany('App\Participant');
    }
}

登记模式：

class Registration extends Model
{
    // a registration has one user that do the registration
    public function customer(){
        return $this->belongsTo(User::class, 'main_participant_id', 'id');
    }

    // a registration can have many participants
    public function participants(){
       return $this->hasMany('App\Participant');
    }

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

    public function payment()
    {
        return $this->hasOne('App\Payment');
    }
}

参与者模型：

class Participant extends Model
{

    // a participant belongs to a registration
    public function registration(){
        return $this->belongsTo('App\Registration');
    }

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

Answer 1

class PaymentController extends Controller
{
    public function showSummary($id = "", $slug = "", $regID){


        $registrationTypeDetails = Registration::with(['participants.registration_type',
        'participants' => function ($query) use($regID){
            $query->select('id', 'registration_type_id', 'registration_id')->where('registration_id', $regID);
        }
        ])->find($regID);

        dd($registrationTypeDetails->toArray());

}
}

现在，我转换为输出array ($registrationTypeDetails->toArray())：

array:7 [▼
  "id" => 1
  "status" => 1
  "conference_id" => 1
  "main_participant_id" => 1
  "created_at" => "2018-05-28 00:00:00"
  "updated_at" => "2018-05-28 00:00:00"
  "participants" => array:1 [▼
    0 => array:4 [▼
      "id" => 1
      "registration_type_id" => 1
      "registration_id" => 1
      "registration_type" => array:4 [▼
        "id" => 1
        "name" => "general"
        "price" => 10000
        "conference_id" => 1
      ]
    ]
  ]
]