[lmikle]

Примерно так:

Код:

SELECT
  S.*,
  G.*,
  K.*
FROM 
  STUDENTS S LEFT JOIN 
  GROUPS G ON S.GroupID = G.ID LEFT JOIN 
  KURATORS K ON S.KuratorID = K.ID
WHERE K.Name = :KNAME