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;
