如何在存储过程中获取多个选择语句的输出

我有以下存储过程。我期望具有单个记录集的输出将有三列（meeting_room_id，slot_id，min_booking_length）作为在存储过程中传递的参数。以下存储过程从第一条select语句给了我记录集。如何使用此存储过程获取预期的输出？

CREATE PROCEDURE validate_meeting_room_booking_slot(
INOUT meeting_room_id BIGINT,IN rent_space_start_time VARCHAR(255),IN rent_space_end_time VARCHAR(255),IN scheduled_date DATE,OUT slot_id BIGINT,OUT min_booking_length INT)
BEGIN
SELECT id INTO @slot_id
FROM meeting_room_booked_slots
WHERE meeting_room_id = meeting_room_id
AND date = scheduled_date
AND (
(start_time AND end_time > rent_space_start_time)
OR
(start_time >rent_space_start_time
AND start_time LIMIT 1;
SELECT meeting_room_id,min_booking_length
FROM meeting_rooms
WHERE id = meeting_room_id
AND deleted_at IS NULL;
END