redundant foreign keys in PostgreSQL - are there any indexing benefits?
(For similar relations simple hierarchy are more sensible... (id, parent))

Apart from that the last foreign key only slows down a bit the DML queries.