Super-resolution microscopy of single atoms in optical lattices