mysql 触发器

Question

mysql 触发器中有两个insert 语句 第二个inert 要用第一个insert 的结果怎么实现

DELIMITER $$

USE `nightclub`$$

DROP TRIGGER /*!50032 IF EXISTS */ `create_histroy_room_statuses`$$

CREATE
    /*!50017 DEFINER = 'root'@'localhost' */
    TRIGGER `create_histroy_room_statuses` BEFORE DELETE ON `room_statuses` 
    FOR EACH ROW 
  BEGIN

    INSERT `nightclub`.histroy_room_statuses (
      room_id,
      note,
      customer_number,
      arrival_time,
      room_game,
      drinks,
      booking_time,
      estimated_time,
      assistant_table,
      visitor,
      cadres_patrol,
      salesman_tip,
      master_tip,
      princess_tip,
      drink_total,
      prs_tip_total,
      towel_number,
      consume,
      pay_method,
      princess_customer_tel,
      princess_customer_name,
      createdAt,
      updatedAt,
      booking_employee_id,
      princess_id,
      salesman_id,
      master_id,
      booking_customer_tel,
      booking_customer_name,
      state,
      enter_time
    ) SELECT 
      room_id,
      note,
      customer_number,
      arrival_time,
      room_game,
      drinks,
      booking_time,
      estimated_time,
      assistant_table,
      visitor,
      cadres_patrol,
      salesman_tip,
      master_tip,
      princess_tip,
      drink_total,
      prs_tip_total,
      towel_number,
      consume,
      pay_method,
      princess_customer_tel,
      princess_customer_name,
      createdAt,
      updatedAt,
      booking_employee_id,
      princess_id,
      salesman_id,
      master_id,
      booking_customer_tel,
      booking_customer_name,
      state,
      enter_time
      FROM `nightclub`.room_statuses
      WHERE room_id = old.room_id;
      
          INSERT INTO histroy_room_status_prs (
        employee_id,
        room_id,
        createdAt,
        updatedAt,
        customer_name,
        customer_tel,
        isExemptFee,
        charge,
        work_time
    ) SELECT
        employee_id,
        room_id,
        createdAt,
        updatedAt,
        customer_name,
        customer_tel,
        isExemptFee,
        charge,
        work_time
    FROM
        room_status_prs WHERE room_id=old.room_id;
  END;
$$

DELIMITER ;

histroy_room_status_prs 表我建立外键 但是获取不到第一个insert 返回的值 该怎么实现 那位高手指点一下谢谢