首先是模型配置 ``` //關聯外表 public function group() { //第一個參數為目標model; 第二個參數為目標表內與本model關聯的字段; 第三個字段為本model對外關聯的字段 return $this->hasMany(UsersGroup::class, 'id', 'users_group_id'); } ``` 然后控制器查詢 ``` $query = Users::select(); $query->with(['group' => function($query1){ $query1->select('id','group_name'); }]); ``` 返回的數據格式 ``` {id: 5, user_name: "趙倩", user_tel: "12345678901", create_time: "2022-05-11 08:35:12", level: 0,…} create_time: "2022-05-11 08:35:12" group: [{id: 2, group_name: "B組"}] id: 5 level: 0 user_name: "趙倩" user_tel: "12345678901" users_group_id: 2 ``` 列表輸出渲染 ``` {field: 'users_group_id', title: '小組名稱', minWidth: 120, align: "center", templet: function (data) { var html = ''; if(data.group[0].id==data.users_group_id){ html=data.group[0].group_name; } return html; }}, ```