[MySql] Select Annidate? (credo)

[optime]

SELECT
   T1.Ragsoc,
   T2.Ragsoc,
   T3.Ragsoc
FROM
   Ut_bro T0 
   LEFT JOIN Utenti T1 ON T0.ID=T1.ID
   LEFT JOIN Utenti T2 ON T0.IDSopra=T2.ID
   LEFT JOIN Utenti T3 ON T0.IDSotto=T3.ID