SELECT * FROM a LEFT JOIN (SELECT user_id,count(user_id) from bGROUP BY user_id) as v1 ON a.user_id= v1.user_id;
3 回答
慕妹3242003
TA貢獻(xiàn)1824條經(jīng)驗(yàn) 獲得超6個(gè)贊
AModel::query()
->from('a')
->join(DB::Raw("SELECT user_id,COUNT(user_id) FROM b
GROUP BY user_id) as v1"),'a.user_id','=','v1.user_id')
->get()
- 3 回答
- 0 關(guān)注
- 423 瀏覽
添加回答
舉報(bào)
0/150
提交
取消