MySQL: How to effectively organize an ordinal relationship?

Question

MySQL

There is an animation base.
There is an ordinal relationship between animations, for example:
First season (vid_id: 1) -> Second season (vid_id: 13) -> Movie (vid_id: 4) -> Third season (vid_id: 10)…

How to organize these links efficiently in MySQL?
And how to correctly make a request to what you offer, for example, by vid_id: 13.

Answer 1

The chain of connections you've provided is not entirely clear.
Having simplified the task for you as much as possible, I can offer an option with one single table,
if I understand the task correctly, then you can organize the Films table which will contain columns - vid_id, season_num. You can operate on data with select...where queries.
I would not advise to produce levels of abstraction - the first, second seasons.
I hope these tips will help you in your endeavors with MySQL!