SQL : Mysql - how to get data for two foreign key columns of same table

SQL : Mysql - how to get data for two foreign key columns of same table
To Access My Live Chat Page,
On Google, Search for "hows tech developer connect"

As promised, I have a hidden feature that I want to share with you.
This is a YouTube's feature which works on Desktop.
First, Ensure that the video is playing before proceeding.
Then, type the letters 'awesome' on the keyboard.
It will change your youtube progress bar into a flashing rainbow.

An introduction to myself in a few words,
Greetings, my name is Delphi.
I can provide you with assistance to help you answer your questions.
SQL : Mysql - how to get data for two foreign key columns of same table
Let me know if you have more specific queries by commenting or chatting with me.
We appreciate your participation, so please feel free to comment below with your answer or insights.
Your answer will be appreciated and acknowledged with a 'heart' from me.
for SQL table two columns - foreign same data : to Mysql key of how get