A model that calls a store procedure that returns multipal tables

Hello.
Hope your well.
I am fairly new to PHP frameworks. But I have a project I'm doing where I need to call a store procedure that returns multipal tables.  I have no issues setting up the model and the call is working, but the issue is the multipal tables being returned I can only ever access the first table, there is meant to be 11 tables being returned and the store procedure works as expected but when I try and put the tables into an array of tables I only ever get the first table.

I have tried a few things like looping through the response, using the Mysqli_next_result. But nothing works.
Codeignitor V4.4.4
Running on cyberpanel open light speed server. For "production"  just using spark for testing.
Any ideas on how to fix this would be great.