Currently I have my website setup like the following.
A custom post type for example TV Show has all the TV Show posts in there.
Then I have posts, which are lets say episodes for these TV Shows. I've put these episodes into their own categories. So a categories name matches the TV Show, and all the episodes in that category are related to that TV Show.
Then I use post meta field, do define the ID of the category in the TV Show pages. Then I am able to run some while loops to get all the posts from that specific category.
This works, and is how i've set it up currently. The problem I feel is that in the long run, the amount of categories will definitely get overwhelming and may slow down the site.
I am looking for a way to possible run a query to move all category posts into a connected state with their respective TV Shows, probably by determining the Category that they are in and matching that name with the TV Show in the custom post type.
If this is possible, or any way to not manually do all these connections from the beginning, it would be great.