Add guards for unsupported subqueries join plan, optimize the possible subqueriese

please fix the spelling of "Recursive"