Laravel get only one column from relation

Question

I have a table user_childrens whose contains id_parent and id_user. I'm trying to list all childrens of the parent with this:

code:

//relation in model via belongsTo
    $idparent = auth('api')->user()->id;
    $list = UserChildren::where('id_parent',$idparent)
        ->with('child:id,name,email')
        ->get();

    return $list->toJson();

The return is:

[
    {
        "id": 1,
        "id_parent": 1,
        "id_user": 1,
        "created_at": null,
        "updated_at": null,
        "child": {
            "id": 1,
            "name": "Mr. Davin Conroy Sr.",
            "email": "[email protected]"
        }
    },
    {
        "id": 4,
        "id_parent": 1,
        "id_user": 2,
        "created_at": null,
        "updated_at": null,
        "child": {
            "id": 2,
            "name": "Krystel Lehner",
            "email": "[email protected]"
        }
    }
]

But it's API so I want only the child column like:

[
    {
        "id": 1,
        "name": "Mr. Davin Conroy Sr.",
        "email": "[email protected]"

    },
    {..}
]

UserChildren Model:

public function child() {
    return $this->belongsTo('App\User','id_user','id');
}

I know that I could do this via .map() on collection but maybe there is other solution already on this query

can you show UserChildren model

Davit Zeynalyan
– Davit Zeynalyan

2018-07-07 18:07:28 +00:00
Commented Jul 7, 2018 at 18:07 — Davit Zeynalyan
– Davit Zeynalyan, Commented Jul 7, 2018 at 18:07
ok, added @Davit

Davidos
– Davidos

2018-07-07 18:12:31 +00:00
Commented Jul 7, 2018 at 18:12 — Davidos
– Davidos, Commented Jul 7, 2018 at 18:12
I update my answer try it and ask about result

Davit Zeynalyan
– Davit Zeynalyan

2018-07-07 18:16:34 +00:00
Commented Jul 7, 2018 at 18:16 — Davit Zeynalyan
– Davit Zeynalyan, Commented Jul 7, 2018 at 18:16

Davit Zeynalyan · Accepted Answer · 2018-07-07 18:23:18Z

1

You can use this code

$idparent = auth('api')->user()->id;
$childs = User::whereHas('user_childrens', function ($query) use ($idparent) {
    $query->where('id_parent', $idparent);
})->get(['id', 'name', 'email']);

dd($childs->toJson());

And User model define user_childrens relation.

public function user_childrens()
{
    return $this->hasMany('App\UserChildren','id_user','id');
}

See also docs https://laravel.com/docs/5.5/eloquent-relationships#querying-relationship-existence

edited Jul 7, 2018 at 18:23

answered Jul 7, 2018 at 18:12

Davit Zeynalyan

8,6485 gold badges33 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Laravel get only one column from relation

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related