Why do you think that recursion is the correct approach here? I don't think it is, because a recursive query needs to maintain the same "shape" throughout and I don't think that is true with your intermediate results.

Drew