自动生成代码生成的sql脚本执行失败

您好，我对数据库不熟悉，不确定是生成的sql语句有问题还是我的使用方法不对，AI对错误的解释是
> VALUES 中直接使用聚合函数 max(menu_id) 的写法是非法的，需要把`max(menu_id)`改成子查询`(SELECT MAX(menu_id) FROM sys_menu)`

## 生成的SQL脚本内容是
```
-- 菜单 SQL
insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
values('产品分类', '1', '1', 'category', 'product_category/category/index', 1, 0, 'C', '0', '0', 'product_category:category:list', '#', 'admin', current_timestamp, '', null, '产品分类菜单');

-- 按钮父菜单ID
select max(menu_id) from sys_menu;

-- 按钮 SQL
insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
values('产品分类查询', max(menu_id), '1',  '#', '', 1, 0, 'F', '0', '0', 'product_category:category:query',        '#', 'admin', current_timestamp, '', null, '');

insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
values('产品分类新增', max(menu_id), '2',  '#', '', 1, 0, 'F', '0', '0', 'product_category:category:add',          '#', 'admin', current_timestamp, '', null, '');

insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
values('产品分类修改', max(menu_id), '3',  '#', '', 1, 0, 'F', '0', '0', 'product_category:category:edit',         '#', 'admin', current_timestamp, '', null, '');

insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
values('产品分类删除', max(menu_id), '4',  '#', '', 1, 0, 'F', '0', '0', 'product_category:category:remove',       '#', 'admin', current_timestamp, '', null, '');

insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
values('产品分类导出', max(menu_id), '5',  '#', '', 1, 0, 'F', '0', '0', 'product_category:category:export',       '#', 'admin', current_timestamp, '', null, '');

```

## 报错信息
```
C:\Users\xtsb\AppData\Roaming\DBeaverData\drivers\clients\postgresql\win\17\psql.exe --host=192.168.124.34 --port=5432 --username=root--echo-errors prodb
任务  'PostgreSQL 脚本' 开始于 Wed Oct 08 12:14:49 CST 2025
INSERT 0 1

max

------

2001

(1 row)

ERROR:  column "menu_id" does not exist

LINE 2: values('产品分类查询', max(menu_id), '1',  '#', '', 1, 0, 'F...

^