Recursive CTE and performance issue when anchor member is a large table sql server

I have a large table with data like below.

Conditional recursive query in sql server

I have these 2 tables: