DB Using CodeIgniter’s Model - $afterFind

http://prntscr.com/t2rr7y

as for me this is also a solution but I need an optimized query using join, maybe someone will advise how to do it even more correctly. Because I could write a join function but it can somehow be implemented in a function that I wrote because it turns out that as many as 52 queries to the database are not good.

the result is what I need

http://prntscr.com/t2ruv4

I am only bothered by the number of requests of them as many as 50 pieces because I still use pagination and there I have to display 25 entries per page

---

but I would like that I created a model somehow add join so that I would not have to write additional functions in the model.

---

http://prntscr.com/t2s012

the screenshot shows that it also works quickly, but if I have a very large base, then I think I need to think something with optimization, and now I want to immediately lay down all the queries normally with a bunch of several tables.

---

http://prntscr.com/t2s5y8

and so I want to call in the controller