弄清楚了。
SELECt users.*, count( posts.user_id ) FROM posts LEFT JOIN users ON users.id=posts.user_id GROUP BY posts.user_id
弄清楚了。
SELECt users.*, count( posts.user_id ) FROM posts LEFT JOIN users ON users.id=posts.user_id GROUP BY posts.user_id
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
