You can use a CTE to do this

; WITH PRODUCT1 AS

(

SELECT*

FROMPRDST AS P

WHEREP.PARENT = 1055874

UNION ALL

SELECTPR.*

FROMPRDST AS PR

INNER JOIN PRODUCT1 AS PR1 ON PR.PARENT = PR1.CHILD

)

SELECT*

FROMPRODUCT1