Feature: support the left child of dependent join contains subquery in from clause

[xudong963]

support the following case:

create table t(a int);
insert into t values(1), (2);
select * from (select a + 1 as a from t) as t where (select sum(a) from t as t1 where t1.a < t.a) = 1;

Originally posted by @leiysky in https://github.com/datafuselabs/databend/pull/6632#discussion_r924209972

[bohutang]

Still error:

500 InternalError =>
Code 500 "internal server error"