(MySQL - Coldfusion/Lucee) -一条MySQL语句，多个插入-如何获取每个subsubCategoryID？

-- 假设有一个名为subsubCategory的表，包含以下列：subsubCategoryID、subCategoryID、categoryID、name
-- 假设有一个名为subCategory的表，包含以下列：subCategoryID、categoryID、name
-- 假设有一个名为category的表，包含以下列：categoryID、name

-- 插入subsubCategory数据，并获取自增ID
INSERT INTO subsubCategory (subCategoryID, categoryID, name) VALUES (1, 1, 'SubSubCategory 1');
SELECT LAST_INSERT_ID() AS subsubCategoryID;

-- 插入subCategory数据，并获取自增ID
INSERT INTO subCategory (categoryID, name) VALUES (1, 'SubCategory 1');
SELECT LAST_INSERT_ID() AS subCategoryID;

-- 插入category数据，并获取自增ID
INSERT INTO category (name) VALUES ('Category 1');
SELECT LAST_INSERT_ID() AS categoryID;