Diagnosing Unrecognized Hard drives
You said that the drive doesn't work with other Macs or in an external enclosure, so the problem is unlikely to be a dodgy cable on your MacBook Pro. If the drive doesn't work with any computer, it's most likely dead. 

At lot of OEM drives have 3-year warranties from the drive manufacturer. Your drive may still be under warranty so I would contact the company and do a warranty claim.

Also, definitely get a known working drive and see if it works with your MBPro.