Improve colocate join validation

[Xpray]

Describe the bug

There are 3 tables A, B, C

the query looks like: A inner join (B left semi join C)

then QP will report that inner join can not be colocated due to "Node type not match"

after change query to (B left semi join C) inner join A, the colocate join works.

I found the code snippet below, and suspect it misses the case that "leftRoot as ScanNode and rightRoot as JoinNode"