Is it a problem to get thousands of backlinks from one website?

There are so many websites with millions of backlinks but few referring domains. Therefore, I wonder how it's possible to have millions of backlinks. Later, I found out they had over one million backlinks coming from one website alone. One million backlinks are impossible to create manually. What is the benefit of this and how does it affect SEO?