Best practice to return multidimensional array

@adqda,

You are basically running 3 queries and using their results to build an array. What I'm saying is instead of running three queries, merge them into one database view with specific field names (from each table). Then call the database view in the application and take the results and put it into an array. Although CI does put it into an array for you it might not be in the array format that you need ( https://codeigniter.com/userguide3/datab...ult-arrays ). I'm assuming that you are using CI3.