首頁 > 問答 > 主體
我現在有兩個表:
一個是協會清單(list)和使用者表(user)
list表的欄位
1
2
<code>list_id(协会id) , list_name(协会名称)
</code>
user用戶表
3
<code>user_id(用户id),list_id(所属协会), username(用户名)
請問如何實作:
關聯查詢取得每個協會下的會員總數
例如:
4
<code>{"list_name":"AAA协会","user_count":20},
<code>{
"list_name"
:
"AAA协会"
,
"user_count"
:20},
{"list_name":"BBB协会","user_count":211}
{
"BBB协会"
:211}
...
請問怎麼關聯呢?
大家讲道理2017-05-16 16:50:52
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
<code>class List extends Model
<code>
class
List
extends
Model
protected $fillable = ['name'];
protected
$fillable
= [
'name'
];
public function users()
public
function
users()
return $this->hasMany(User::class, 'list_id', 'id');
return
$this
->hasMany(User::
'list_id'
'id'
);
}
class User extends Model
User
protected $fillable = ['list_id'];
public function list()
list()
return $this->belongsTo(List::class, "list_id", "id");
->belongsTo(List::
"list_id"
"id"
List::withCount("users")->paginate();</code>
List::withCount(
"users"
)->paginate();</code>
多看文件。