Retrieving data from database tables that relay on parent table to generate a JSON object

I have created tables with this structure:

and I am trying to retrieve a game data with all its information and build a JSON object from PHP. I achieved this but I am not confident with my approach.

here is my php code:

please share your thoughts on how to make this better or if you have tips regarding ERD / PHP code.