The Common Table Expression worked great and I was able to accomplish what I needed. As far as the 2 parents goes, 2 FK's that can be NULL within...

Thank you the recursive cte is what I was looking for and will hopefully be able to obtain all members of the family.