Using a CTE for a recursive select

RecursiveCTE.sql

WITH CTE_ITEM_HIERARCHY AS
(
    SELECT   i.[ItemID]
		    ,i.[Text]
		    ,i.[ParentItemID]
    FROM [dbo].[Item] AS i
	WHERE i.[ParentItemID] = 0
    
    UNION ALL

    SELECT   i2.[ItemID]
		    ,i2.[Text]
		    ,i2.[ParentItemID]
    FROM CTE_ITEM_HIERARCHY AS cte
		INNER JOIN [dbo].[Item] i2
			ON i2.[ParentItemID] = cte.[ItemID]
)

SELECT * FROM CTE_ITEM_HIERARCHY
OPTION (MAXRECURSION 0)