You're also confused about the meaning of recursion.  Recursion is when one CTE refers to itself, not when one query references another.  Even if you use a CTE, I see no reason to make it recursive.

Drew