Insert data in multiple tables
For PostgerSQL:

with acupressure_point_data as ( -- insert into first table with output
                                 insert into acupressure_point(id, url)
                                 values('LL909', 'ww/33/11')
                                 returning id as acupressure_point_id )
-- insert into second table, use CTE output
insert into acupressure_point_region_sub_type(acupressure_point_id, region_sub_type_id)
SELECT acupressure_point_id , '9898'
FROM acupressure_point_data
-- return id for both tables 
returning acupressure_point_id, id as acupressure_sub_type_id;


MySQL does not allow INSERT in CTE. Use separate queries and LAST_INSERT_ID().