SQL中根据一张表的数据去掉另一张表的重复数据

user_a表如下：

user_b表如下：

查询语句如下：

SELECT
user_a.`user`,
Sum(user_a.money),
Count(user_a.`user`)
FROM
user_a
GROUP BY
user_a.`user`
HAVING
user_a.`user` NOT IN ((select user from user_b group by user))

运行结果：