select c.category_name, c.parent_Id, g.Id_goods, g.Goods_name, c.id_category
from goods as g
left join category as c on c.id_category = g.id_category
SELECT * FROM `table` WHERE STR_TO_DATE(`date`, '%d.%m.%Y') >= CURDATE() AND STR_TO_DATE(`date`, '%d.%m.%Y') <= CURDATE() + INTERVAL 7 DAY