>>4117541Primes fulfill a different purpose than zooms, hence why you normally don't get them at complementary but at overlapping focal ranges. A prime forces you to interact with your subject much more than a zoom does, and it rewards you with much more creative and somewhat more high-quality photos. A prime's response to things like direct sunlight or low light and it's larger comparative aperture will allow you to get more characteristic photos of your cat (and other stuff).
For your purposes, the Sony FE 50 mm might be a good option - it's a nifty fifty (somewhere between normal focal lengths and portraiture) with a 1:1 magnification. If you want to go wider and closer, there's also the Laowa 25 mm 2:1, which is an excellent lens, although manual only. Generally, I would recommend you to look into Laowa's macro lenses - they're generally within the portraiture range and are about as good as it gets. (Though, mind you, manual only.)
Sony's offers in the standard zoom ranges 20/28-70 are excellent and there are plenty of more affordable budget options. I'm not a Sony user myself, so maybe someone else can give you a more informed opinion.
