我有兩個表用戶和支付請求
我的用戶表如下
和payment_request表如下
我想使用 laravel eloquent 將 payment_request 表連接到用戶表，這是我的代碼
$user_payment_request_list = PaymentRequest::join('currency','currency.id','=','payment_requests.currency_id')
->join('users','users.id','=','payment_requests.sender_id')
// ->join('users','users.id','=','payment_requests.receiver_id')
->get([
'currency.name as currency_name',
'payment_requests.amount',
'payment_requests.status',
'payment_requests.description',
'payment_requests.sender_id',
'users.name as sender_name',
'users.name as receiver_name',
'payment_requests.transaction_id',
'payment_requests.branch_id',
'payment_requests.created_at',
'payment_requests.updated_at',
])
->where("sender_id",$id);
我得到了覆寫receiver_id的輸出，并從sender_id給了我相同的結果
uj5u.com熱心網友回復：
試試這個查詢：
$user_payment_request_list = PaymentRequest::join('currency','currency.id','=','payment_requests.currency_id')
->join('users as sender_user', 'sender_user.id','=','payment_requests.sender_id')
->join('users as receiver_user', 'receiver_user.id','=','payment_requests.receiver_id')
->get([
'currency.name as currency_name',
'payment_requests.amount',
'payment_requests.status',
'payment_requests.description',
'payment_requests.sender_id',
'sender_user.name as sender_name',
'receiver_user.name as receiver_name',
'payment_requests.transaction_id',
'payment_requests.branch_id',
'payment_requests.created_at',
'payment_requests.updated_at',
])
->where("sender_id", $id)
->get();
我使用 SQLAS命令重命名用戶表。
轉載請註明出處，本文鏈接：https://www.uj5u.com/yidong/384626.html