Recursive CTE implementation on pyspark databricks

I am trying to convert the sql server recursive CTE query to databricks spark equivalent.

Recursive CTE implementation on pyspark databricks

I am trying to convert the sql server recursive CTE query to databricks spark equivalent.