more tables created when create a new site

Yes, this is the correct behavior, and no, there is nothing you can do about it in a multi-site setup. But that’s usually not a problem; disk space is cheap.

Maybe you could run a workaround with a single-site installation and rewrite rules to map subdomains to URLs like /author/post-name/. But that sounds like a collsion magnet; so I wouldn’t recommend it.