Microsoft have come up with a solution for this called private DNS fallback.
There is now a check box within the site-link configuration, that allows the private dns resolver or [insert private DNS solution] to fall back to Azure DNS if there is no record in the linked private DNS zone for the requested resource.

https://learn.microsoft.com/en-us/azure/dns/private-dns-fallback