Best practice to return multidimensional array

@adqda,

I'm going to assume that you are using a current version of MySQL. Why don't you create a database view that has all of the information you need from all three tables. Then in your CI model. All you have to do is call the database view and you will have all the information you need.