mysql存储过程游标嵌套while

DELIMITER //

CREATE PROCEDURE NestedWhileCursor()
BEGIN
    DECLARE done INT DEFAULT FALSE;
    DECLARE v_id INT;
    DECLARE v_name VARCHAR(255);
    DECLARE cur1 CURSOR FOR SELECT id, name FROM table1;
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

    OPEN cur1;

    read_loop: LOOP
        FETCH cur1 INTO v_id, v_name;
        IF done THEN
            LEAVE read_loop;
        END IF;

        -- 嵌套的 WHILE 循环
        DECLARE v_count INT DEFAULT 0;
        DECLARE cur2 CURSOR FOR SELECT COUNT(*) FROM table2 WHERE table2.id = v_id;
        OPEN cur2;

        nested_loop: LOOP
            FETCH cur2 INTO v_count;
            IF done THEN
                LEAVE nested_loop;
            END IF;

            -- 处理嵌套循环中的逻辑
            SELECT CONCAT('ID: ', v_id, ', Name: ', v_name, ', Count: ', v_count) AS result;
        END LOOP;

        CLOSE cur2;
    END LOOP;

    CLOSE cur1;
END //

DELIMITER ;