How does mysql stored procedure receive the result set of another stored procedure

  mysql, question

I want to do a statistics, the first stored procedure is to look up by time. Then use the result set query in the second stored procedure. Many people say that stored procedures do not return result sets. What should they do

Create a temporary table in the stored procedure to insert the required data into the data table