一个具有两个外键的表的sql，导致笛卡尔积

I am fairly new to SQL and I am stuck with this query. So I have a table that contains two foreign keys to the same table. The result I require just won't show up using joins. I have created a I am fairly new to SQL and I am stuck with this