Please Help - Massive Database design problem

Attached is a picture - the top is a chart I threw together to help keep track of categories and options. The bottom is how the information will be displayed in a web page. FYI-it is going to be in mysql and php will be retrieving the info

There are "variations" and each variation can have 1-5 Main Cats associated to it. And in those Main Cats there are 1-2 groups(A&B) and each of those groups have subcategories that are associated with them and then on top of all that the subcategories have options on them.

-The main cats are the same for both groups
-The subcats for the most part are the same for both groups except for 3 which only apply to one group or the other. They could have the exact same subcats & those 3 wouldn't never be used for the other group.
-Most subcats have 2-4 options a handful have no options

Confused yet?

My problem is how do you design a database that works with all this information and doesn't kill the server.

Any help or ideas would be greatly appreciated.