Japan’s fairly simple urban zoning scheme seems to work quite well. There’s essentially a sliding scale from light residential to heavy industrial, but “lighter” uses are always allowed in “heavier” zones.
As far as I know, this is true of the American zoning system, as well.
I'm not sure how that compares to Japan's system, but from GP's comment it sounds like you can cross categories there.
American zoning codes get really complicated really fast, particularly around what businesses are considered low-nuisance in what neighborhood. Especially the moment people start getting worried about parking. Particularly home businesses, like daycare, hair salons, even the humble lemonade stand can all be zoned down to a single hair.