Laravel自定义字符串作为字段

How would I convert the following statement into laravel's eloquent or Query builder:

Select *, 'admin' as type from users.

its the 'admin' as type is where im having problem in converting it on laravel. Thanks

I would rather figure out why MSSQL is handling it that way, or the adapter but since that raw SELECT directly on the connection works, you can do that with Eloquent as well:

App\User::fromQuery("select *, 'admin' as type from users");

You will have a Collection of models hydrated from that result.

Using query builder your can try it like this

$users = DB::table('users')->selectRaw("*, 'admin' AS type")->get();

And if you have User model then

$users = User::selectRaw("*, 'admin' AS type")->get();

As suggested by lagbox. This query returns what I need. Thank you all.

DB::select("select *, 'admin' as type from users")