Consistent LogicalPlan subquery handling in TreeNode::apply and TreeNode::visit #25449

Job	Run time
Check cargo fmt	39s
build with wasm-pack	2m 5s
cargo check	8m 46s
cargo test (macos)	14m 53s
cargo test (macos-aarch64)	9m 7s
Verify MSRV (Min Supported Rust Version)	6m 59s
Verify Vendored Code	58s
cargo test (win64)	43m 30s
cargo test (amd64)	9m 22s
cargo examples (amd64)	10m 30s
cargo test datafusion-cli (amd64)	3m 43s
check Cargo.toml formatting	3m 13s
check configs.md is up-to-date	2m 57s
clippy	5m 2s
circular dependency check	2m 40s
cargo test hash collisions (amd64)	8m 35s
cargo doc	3m 50s
cargo test doc (amd64)	11m 23s
Run sqllogictest with Postgres runner	3m 10s
cargo test pyarrow (amd64)	2m 45s
verify benchmark results (amd64)	10m 16s
	2h 44m 23s

Provide feedback