join 时候如何把on条件用到左右的索引上

select sum(cnt) from (
select count(1) cnt from table_a a where
a.taker_user_id in (10009428992,153290952704) and
a.created_at >= “2023-09-06”
AND a.created_at < DATE_ADD(“2023-09-06”, INTERVAL 1 DAY)

UNION
ALL

select count(1) from table_a a where
a.maker_user_id in (10009428992,153290952704) and
a.created_at >= “2023-09-06”
AND a.created_at < DATE_ADD(“2023-09-06”, INTERVAL 1 DAY))

这样写呢