MariaDB 10.5

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE IF NOT EXISTS `table1` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(99) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

INSERT INTO `table1` (`id`, `name`) VALUES
    (2, 'Blablifdsfsdfsdfsd'),
    (3, 'Fdsfsdfds');

CREATE TABLE IF NOT EXISTS `table2` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `container` int(10) unsigned NOT NULL,
  `sort` int(3) unsigned NOT NULL,
  `name` varchar(99) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

INSERT INTO `table2` (`id`, `container`, `sort`, `name`) VALUES
    (3, 2, 0, 'Fsdfds'),
    (4, 3, 0, 'Fsdfsdfds'),
    (5, 3, 1, 'Fdsfsdfsd');

CREATE TABLE IF NOT EXISTS `table3` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `container` int(11) unsigned NOT NULL,
  `choice` int(11) unsigned NOT NULL,
  `sort` int(3) unsigned NOT NULL,
  `type` varchar(20) NOT NULL DEFAULT '',
  `refId` int(11) unsigned NOT NULL,
  `extraCharge` float NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

INSERT INTO `table3` (`id`, `container`, `choice`, `sort`, `type`, `refId`, `extraCharge`) VALUES
    (1, 2, 3, 0, 'category', 39, 0),
    (2, 2, 3, 1, 'category', 40, 0),
    (3, 2, 3, 2, 'category', 19, 0),
    (4, 2, 3, 3, 'category', 23, 0),
    (8, 3, 4, 0, 'category', 39, 0),
    (9, 3, 4, 1, 'category', 17, 0),
    (10, 3, 4, 2, 'category', 40, 0),
    (11, 3, 4, 3, 'category', 36, 0),
    (12, 3, 3, 0, 'item', 22, 0),
    (13, 3, 3, 1, 'category', 40, 0),
    (14, 3, 3, 2, 'category', 36, 0),
    (15, 3, 3, 3, 'category', 41, 0),
    (16, 3, 3, 4, 'category', 26, 0);

SELECT 
    JSON_ARRAYAGG(
        JSON_OBJECT(
            "name", name,
            "choices", choices
        )
        ORDER BY name) AS choices
FROM (
    SELECT t1name as name, 
        JSON_ARRAYAGG(
            JSON_OBJECT(
                "name", name,
                "possibilities", possibilities
            )
            ORDER BY name
        ) AS choices
    FROM (
        SELECT table1.name AS t1name, table2.name AS name,
            JSON_ARRAYAGG(
                JSON_OBJECT(
                    "id", table3.id,
                    "extraCharge", table3.extraCharge
                )
                ORDER BY table3.sort
            ) AS possibilities
        FROM table1
        LEFT JOIN table2 ON table2.container = table1.id
        LEFT JOIN table3 ON table3.choice = table2.id
        GROUP BY table1.id
    ) AS t
  ) AS t;

Records: 2  Duplicates: 0  Warnings: 0

Records: 3  Duplicates: 0  Warnings: 0

Records: 13  Duplicates: 0  Warnings: 0

choices
[{"name": "Blablifdsfsdfsdfsd", "choices": "[{"name": "Fsdfds", "possibilities": "[\"{\\\"id\\\": 12, \\\"extraCharge\\\": 0}\",\"{\\\"id\\\": 1, \\\"extraCharge\\\": 0}\",\"{\\\"id\\\": 13, \\\"extraCharge\\\": 0}\",\"{\\\"id\\\": 2, \\\"extraCharge\\\": 0}\",\"{\\\"id\\\": 14, \\\"extraCharge\\\": 0}\",\"{\\\"id\\\": 3, \\\"extraCharge\\\": 0}\",\"{\\\"id\\\": 15, \\\"extraCharge\\\": 0}\",\"{\\\"id\\\": 4, \\\"extraCharge\\\": 0}\",\"{\\\"id\\\": 16, \\\"extraCharge\\\": 0}\"]"},{"name": "Fsdfsdfds", "possibilities": "[\"{\\\"id\\\": null, \\\"extraCharge\\\": null}\",\"{\\\"id\\\": 8, \\\"extraCharge\\\": 0}\",\"{\\\"id\\\": 9, \\\"extraCharge\\\": 0}\",\"{\\\"id\\\": 10, \\\"extraCharge\\\": 0}\",\"{\\\"id\\\": 11, \\\"extraCharge\\\": 0}\"]"}]"}]

choices

[{"name": "Blablifdsfsdfsdfsd", "choices": "[{"name": "Fsdfds", "possibilities": "[\"{\\\"id\\\": 12, \\\"extraCharge\\\": 0}\",\"{\\\"id\\\": 1, \\\"extraCharge\\\": 0}\",\"{\\\"id\\\": 13, \\\"extraCharge\\\": 0}\",\"{\\\"id\\\": 2, \\\"extraCharge\\\": 0}\",\"{\\\"id\\\": 14, \\\"extraCharge\\\": 0}\",\"{\\\"id\\\": 3, \\\"extraCharge\\\": 0}\",\"{\\\"id\\\": 15, \\\"extraCharge\\\": 0}\",\"{\\\"id\\\": 4, \\\"extraCharge\\\": 0}\",\"{\\\"id\\\": 16, \\\"extraCharge\\\": 0}\"]"},{"name": "Fsdfsdfds", "possibilities": "[\"{\\\"id\\\": null, \\\"extraCharge\\\": null}\",\"{\\\"id\\\": 8, \\\"extraCharge\\\": 0}\",\"{\\\"id\\\": 9, \\\"extraCharge\\\": 0}\",\"{\\\"id\\\": 10, \\\"extraCharge\\\": 0}\",\"{\\\"id\\\": 11, \\\"extraCharge\\\": 0}\"]"}]"}]