Hi
On most computer power supplys there are several SATA power connectors and possibly a MOLEX 4 pin connector as well on a cable.
Provided the cables are long enough to connect easily you can connect hard drives, SSD's & optical drives on same cable.
If you had 2 or 3 hard drives on one cable you may want to spread the load onto another cable
regards
Mike Barnes