Support the ongoing development of Laravel.io →
amerelhalabi
posted 10 years ago
Database Eloquent

Hello ! I have a table that contains Pages with columns (ID,Title,Parent_id) page can be root(Parent_id=0) , or child (Parent_id is ID of parent page )

how can i get a result like :

Page | Title | Parent_name ?

can I use left join ? how ? thanx

Last updated 3 years ago.
0

Sign in to participate in this thread!

Eventy

Your banner here too?

AmerElhalabi amerelhalabi Joined 25 Nov 2014

Moderators

We'd like to thank these amazing companies for supporting us

Eventy NativePHP
Fathom
Forge
Envoyer
Beyond Code
BairesDev
N-iX
Litslink

Your logo here?

Laravel.io

The Laravel portal for problem solving, knowledge sharing and community building.

Laravel.io

Forum Articles Pastebin

Socials

X (Twitter) Bluesky Bluesky GitHub

The community

Laravel Laravel Laravel News Laravel News
Laracasts Laracasts Laravel Podcast Laravel Podcast
© 2025 Laravel.io - All rights reserved.
Terms of service Privacy policy Advertise