两表
retail_user表的id关联retail_order表的uid
主表:
子表:
代码:
控制器:
public function people(Request $request)
{
//分销员管理视图
// return view('Distribution/AdminRetail');
$data=userModel::with('selectuser')->select();
print_r($data->toArray());
}
主表模型:
class userModel extends Model
{
protected $table='retail_user';
public function selectuser()
{
//hasOne代表关联一张表 hasMany多张表 参数一:要关联的表 参数二:要关联表的外键 参数三:本表键
return $this->hasOne(OrderModel::class,'uid','id');
}
}
子表模型:
class OrderModel extends Model
{
protected $table='retail_order';
}
效果:
Array
(
[0] => Array
(
[id] => 1
[name] => 用户1
[pwd] => 123456
[capt] => 0
[img] => https://img2.baidu.com/it/u=2860188096,638334621&fm=253&app=138&size=w931&n=0&f=JPEG&fmt=auto?sec=1663347600&t=f3dab1b92ce00ecf134728ae47344db0
[selectuser] => Array
(
[id] => 1
[order_name] => 苹果
[price] => 50
[uid] => 1
[sum] => 80
)
)
[1] => Array
(
[id] => 2
[name] => 用户2
[pwd] => 123456
[capt] => 0
[img] => https://img2.baidu.com/it/u=2860188096,638334621&fm=253&app=138&size=w931&n=0&f=JPEG&fmt=auto?sec=1663347600&t=f3dab1b92ce00ecf134728ae47344db0
[selectuser] => Array
(
[id] => 2
[order_name] => 袜子
[price] => 12
[uid] => 2
[sum] => 100
)
)
[2] => Array
(
[id] => 3
[name] => 用户3
[pwd] => 123456
[capt] => eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJkYXRhIjoiMSJ9.ths4M_lfye7DgvAZ0u6sUJxk7Q1poWuQ8KdXPSeppc4
[img] => https://img2.baidu.com/it/u=2860188096,638334621&fm=253&app=138&size=w931&n=0&f=JPEG&fmt=auto?sec=1663347600&t=f3dab1b92ce00ecf134728ae47344db0
[selectuser] => Array
(
[id] => 3
[order_name] => 帽子
[price] => 78
[uid] => 3
[sum] => 90
)
)
[3] => Array
(
[id] => 4
[name] => 用户4
[pwd] => 123456
[capt] => eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJkYXRhIjoiMSJ9.ths4M_lfye7DgvAZ0u6sUJxk7Q1poWuQ8KdXPSeppc4
[img] => https://img2.baidu.com/it/u=2860188096,638334621&fm=253&app=138&size=w931&n=0&f=JPEG&fmt=auto?sec=1663347600&t=f3dab1b92ce00ecf134728ae47344db0
[selectuser] => Array
(
[id] => 4
[order_name] => 西瓜
[price] => 36
[uid] => 4
[sum] => 30
)
)
)