How to quickly find out failed disks’ SATA port in Linux? (how to map Linux disk names to SATA ports)

I find one disk failed on my server which have several ones installed. I know the disk’s name in Linux (e.g. sda, sdb). However, the Linux disk name to SATA port mapping does not follow the same order. Now, I want to find out the failed disks. How to quickly find out them and which SATA port are these failed disks connected to?

Please find the method here:

How to Find Out Failed Disks’ SATA Ports in Linux