Сергей Волков

SELECT user_id, SUM(CASE WHEN value<0 THEN value ELSE 0 END) as spent, 
SUM(CASE WHEN value>0 THEN value ELSE 0 END) as received, SUM(value) as total
FROM table
GROUP BY user_id