Currently there are 9 native Macro Prime lenses for Nikon Z5 II and 4 of these lenses are autofocus (AF) type.
Z5 II also has a sensor based image stabilization system which means that all of these lenses will be stabilized when used on Z5 II.
Since Nikon Z5 II has environmental sealings (Weather Sealing), you may like to couple your camera with one of these 4 Macro Prime lenses with Weather Sealings.