MySQL 5.7

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE IF NOT EXISTS `_lines` (
  `id` int(11) NOT NULL,
  `name` varchar(50) COLLATE utf8_bin NOT NULL DEFAULT '',
  `sum` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

INSERT INTO `_lines` (`id`, `name`, `sum`) VALUES
	(1, 'burger', 1);

CREATE TABLE IF NOT EXISTS `_ingr` (
  `id` int(11) NOT NULL,
  `line_id` int(11) NOT NULL,
  `name` varchar(50) COLLATE utf8_bin NOT NULL DEFAULT '',
  `sum` int(11) NOT NULL,
  `type` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK___lines` (`line_id`),
  CONSTRAINT `FK___lines` FOREIGN KEY (`line_id`) REFERENCES `_lines` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

INSERT INTO `_ingr` (`id`, `line_id`, `name`, `sum`, `type`) VALUES
	(1, 1, 'onion', 2, 0),
	(2, 1, 'garlic', 3, 0),
	(3, 1, 'carrot', 4, 1),
	(4, 1, 'tomato', 5, 1),
	(5, 1, 'pepper', 6, 2);
SELECT CONCAT(_lines.name, 
               CASE WHEN type 
                    THEN CONCAT('|', 
                                ANY_VALUE(ingr.name)) 
                    ELSE '' 
                    END) name, 
       SUM(ingr.`sum`) `sum`, 
       ANY_VALUE(ingr.type) type
FROM _lines
JOIN ( SELECT id, line_id, name, `sum`, type
       FROM _ingr
       UNION ALL
       SELECT 0, id, name, `sum`, 0
       FROM _lines ) ingr ON _lines.id = ingr.line_id
GROUP BY _lines.name, (ingr.type > 0) * ingr.id, ingr.type;


name
sum
type


burger
6
0

burger|carrot
4
1

burger|tomato
5
1

burger|pepper
6
2


SELECT CASE WHEN ANY_VALUE(I.type) = 0
            THEN L.name
            ELSE CONCAT(L.name, '|', ANY_VALUE(I.name))
            END name,
       CASE WHEN ANY_VALUE(I.type) = 0
            THEN SUM(I.`sum`) + ANY_VALUE(L.`sum`)
            ELSE ANY_VALUE(I.`sum`)
            END `sum`,
       ANY_VALUE(I.type) type
FROM _lines L
JOIN _ingr I ON L.id = I.line_id
GROUP BY L.name, (I.type > 0) * I.id;


name
sum
type


burger
6
0

burger|carrot
4
1

burger|tomato
5
1

burger|pepper
6
2