Finding a root id using multiple nested joins - Is there a more performant option?

Hello,   I have a table that includes a column containing previous_ids. I want to use this column to find each record's root id. Some records don't have a previous_id and some previous_id's lead to...