If you want to model this using your filesystem, that's exactly why symlinks (shortcuts on Windows and Mac) were invented.
On Mac, you can write tags on files and then use Spotlight to search for them. Pick one (more or less arbitrary) primary category to use as the directory for the file, then write tags for the other ways you want to be able to search for it.
