The bad news is that most SATA controllers don't support this. If you can look at the motherboard specs, you can see if the controller supports this or not. If not, your choices include
Buy a motherboard that does
Buy an add-in SATA controller with either 8 ports or support for port multipliers.
Spend a ton of money to buy a RAID device that does hardware RAID, takes eight drives, and will connect to your mobo with a single ESata connection. This is, in a sense, an "SATA hub," but a very expensive one.