how to get the result of second select statement in mysql using python?

I am using python to make a connection with the mySql database and run a procedure. In the procedure, there are two select statements that return the result. I am using the following code to execute procedure

query = "Call procedure_name()"
cursor.execute(query)
procedureResult = cursor.fetchall();

but this returns the only result of the first select statement. How can I get the result of second select?

procedure

DELIMITER $$

USE `my_database`$$

DROP PROCEDURE IF EXISTS `dim_get_orders`$$

CREATE DEFINER=`root`@`%` PROCEDURE `dim_get_orders`()
 BEGIN
SELECT 'hi';

SELECT 'hello';
END$$

DELIMITER ;