mysql中的存储过程嵌套游标循环不执行所有结果

DELIMITER //

CREATE PROCEDURE NestedCursorExample()
BEGIN
    DECLARE outer_done INT DEFAULT FALSE;
    DECLARE inner_done INT DEFAULT FALSE;
    
    DECLARE outer_cur CURSOR FOR SELECT id FROM table1;
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET outer_done = TRUE;
    
    OPEN outer_cur;
    
    read_outer: LOOP
        FETCH outer_cur INTO @outer_id;
        IF outer_done THEN
            LEAVE read_outer;
        END IF;
        
        DECLARE inner_cur CURSOR FOR SELECT name FROM table2 WHERE id = @outer_id;
        DECLARE CONTINUE HANDLER FOR NOT FOUND SET inner_done = TRUE;
        
        OPEN inner_cur;
        
        read_inner: LOOP
            FETCH inner_cur INTO @inner_name;
            IF inner_done THEN
                LEAVE read_inner;
            END IF;
            -- 处理内层游标数据
            SELECT @inner_name;
        END LOOP;
        
        CLOSE inner_cur;
        SET inner_done = FALSE; -- 重置内层游标的完成标志
    END LOOP;
    
    CLOSE outer_cur;
END //

DELIMITER ;

START TRANSACTION;
-- 执行游标相关的操作
COMMIT; -- 或者 ROLLBACK 根据实际情况