Create recursive CTE for this table

0


I have a table like this:

|id     |name      |parent|
+-------+----------+------+
|1      |iran      |      |
|2      |iraq      |      |
|3      |tehran    |1     |
|4      |tehran    |3     |
|5      |Vaiasr St |4     |
|6      |Fars      |1     |
|7      |shiraz    |6     |
It's about addresses from country to street. I want to create address by recursive cte like this:

with cte_address as
(
    select 
        ID, [Name], parent
    from 
        [Address]
    where 
        Parent is null
    union all
    select
        a.ID, a.[name], a.Parent
    from 
        address a
    inner join 
        cte_address c on a.parent = c.id
)
select *  
from cte_address
But I get an error:

The statement terminated. The maximum recursion 100 has been exhausted before statement completion.