Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.

SGUserFace's avatar

return specific columns

How can I get only specific columns?

I tried to use get and select And it did not resolve

Route::middleware('auth:sanctum')->get('/user', function (Request $request) {
    return $request->user();
});
0 likes
2 replies
tykus's avatar
tykus
Best Answer
Level 104

The User instance is already fetched, so query methods (select and get) are useful only if you query for the authenticated user again.

Route::middleware('auth:sanctum')->get('/user', function (Request $request) {
    return User::select(/* columns */)->find($request->user()->id);
});

Otherwise, you can return an array representation of the User:

Route::middleware('auth:sanctum')->get('/user', function (Request $request) {
    return [
        'id' => $request->user()->id,
        'name' => $request->user()->name,
        'email' => $request->user()->email,
        // ...
    ];
});
1 like

Please or to participate in this conversation.