Support UNION in select subquery fields

Feature Request

Is your feature request related to a problem? Please describe:

TiDB doesn't support UNION expressions inside subquery in select fields.

select ((select count(a)) union (select count(b))) from t;

Describe the feature you'd like:

Support it like what MySQL does.

Describe alternatives you've considered:

Teachability, Documentation, Adoption, Migration Strategy: