fix(optimizer): ban using subquery in non-table-in-out function.

fix(optimizer): ban using subquery in non-table-in-out function. #29345