Two Zigbee Hub in one network

It would not. You likely only need one zigbee hub.

First let’s clarify 3 types of zigbee devices. The zigbee hub you’re referencing here, is a “coordinator”.
What is the difference between an end device, a router, and a coordinator? Do I - Silicon Labs (silabs.com)

And since zigbee is mesh and outside of wifi, people generally littered all kinds on powered zigbee (plugs, bulbs, etc.) devices as the relaying routers throughout the house, to build one strong zigbee network.

You could even do zigbee usb dongle (as coordinator) plugging directly to your HA server, and then using the same set of powered zigbee devices to expand your network to cover the entire house.

Which “zigbee hub” your are using, specifically?
Let us know what you have in mind, and whether you need some recommendations.

EDIT 4-Sep-2023 - The SiLab knowledge base link above is not being maintained any more. Here’s the latest:
zigbee_applications/zigbee_concepts/Zigbee-Introduction/Zigbee Introduction - Node Types, PanId, Addressing.md at master · SiliconLabs/zigbee_applications · GitHub