ID       parent_id   name
---------------------
1        2            first 
2        4            second
3        3            third
4        5            fourth
5        -           fifth

Ancestors list of first should be (2, 4, 5)

sql sql-server
Edit
Report