SELECT SUM(CASE WHEN user_name='孙悟空' THEN kills END) AS '孙悟空',SUM(CASE WHEN user_name='猪八戒' THEN kills END) AS '猪八戒',SUM(CASE WHEN user_name='沙僧' THEN kills END) AS '沙僧' FROM user1 a JOIN user_kills b ON a.id=b.user_id;
