Assigning multiple values to product database

The proper way to do this would be through correct database structure as you hinted. Another option is to store aluminum and wood as a JSON string array in one column. So in your database it would show item: item1, materials: {wood, aluminum}