product
--------
id | name
price
------
id | value
product_to_price
-------------------------
product_id | price_id
price
---------------
id | product_id | value
SELECT s.`name`, SUM(s.`price`)
FROM `claim` c
LEFT JOIN `subclaim` s
ON c.`id` = s.`zayavkaid`
GROUP BY s.`id`