How do I join same table miltiple times?

  laravel, postgresql

I have only one table and I want to join that table multiple times. How do I perform multiple join in same table?enter image description here From the image, I got Taplejung containing id 4708 and I got Taplejung Municipality which has parent_id 4708. I just want that two value in same column. For example: Taplejung – Taplejung Municipality.
I do search for answer but could not find any but if this question is duplicate please do tell me. Anything I have to add then I will add. Thank you

Source: Laravel

Leave a Reply