Redmine

it's very often the case that issues should be assigned to several categories at the same time.
to make this very flexible, you can get rid of "issue category" concept and replace it with "labels". 1 category == 1 label.
users can add as many "labels" as necessary to issues.

this is the way Google Code project hosting and Github chose and it's quite convenient.