This question may not be related to Percona but for sure related to MySQL.
I am a not an expert in MySQL world and looking for a solution like
I don’t think there is any available option ready in MySQL to achieve similar goal.
But I think you may be interested in Shard-Query:
https://github.com/greenlion/swanhart-tools/wiki/Shard-Query-in-depth#wiki-Sharding_Support