I have below MySQL database table which has a recursive relationship. A hospital maybe managed by another main hospital in this scenario. I have a difficult time trying to retrieve all data with name of the hospital which manages another hospital.
Some expert help would be much helpful for me. Thanks.