How to rename relation function in eloquent?

Question

I using Laravel 5.3 .this my query and I want in result array the 'children_rec' renamed to 'node'.

 $boxes = Boxes::with('children_rec')
                ->whereNull('box_id')
                ->with('position')
                ->get()
                ->toJson(128);

UPDATE: Relation code:

public function child()
{
    return $this
        ->hasMany('PTA_OIMS\Boxes', 'box_id');
}

public function children_rec()
{
    return $this->child()
        ->with('children_rec')
        ->with('position');
}

thanks

What does the return structure look like? Why can't you just manipulate the array? — tadman, Oct 09 '17 at 13:41
Edit your question to include any relevant code, please don't add it as a cluttered comment. — tadman, Oct 09 '17 at 13:44
Maybe this can help: https://stackoverflow.com/questions/25549526/how-to-alias-in-laravel-eager-loading — Hedegare, Oct 09 '17 at 14:01
You can use attribute accessors as described in: https://stackoverflow.com/questions/27867569/laravel-eloquent-serialization-how-to-rename-property — Ramses, Nov 18 '18 at 16:17

score 0 · Answer 1 · answered Oct 09 '17 at 13:55

I don't think Laravel supports aliasing a relationship.

You should rename your relation to your desired name:

public function node()
{
    return $this->child()
        ->with('node')
        ->with('position');
}

Then you can call it like:

$boxes = Boxes::with('node')
               ->whereNull('box_id')
               ->with('position')
               ->get()
               ->toJson(128);

score 0 · Answer 2 · answered Nov 18 '18 at 16:22

Using attribute accessors to hide the relationship and then show the accessor in the results, for example:

public function getNodeAttribute() {
  return $this->children_rec;
}
protected $hidden = array('children_rec');
protected $appends = array('node');

How to rename relation function in eloquent?

2 Answers2