一般求和 select sum(money) from user group by id; 按条件求和 select sum(if(type=1,money,0)) from user group by id;