Recursive CTE SQL Server

recursive.sql

with cte as (
	select id, parentId, name from Category where id = 17
	union all
	select c.id, c.parentId, c.name from Category c
		join cte on c.id = cte.parentId
) select * from cte