Denis Holub

SELECT SUM(bonus), nlevel(tree) - nlevel('2.383') AS level
FROM "user" 
INNER JOIN "bonus_item" 
ON user_from = "user".id 
AND user_to = 383
WHERE (tree ~ '2.383.*{0,5}') 
AND ("mounth" = '9:2017')
GROUP BY nlevel(tree) - nlevel('2.383')
order by nl;