The abundance and spatial distribution of ultra-diffuse galaxies in nearby galaxy clusters