Controller File name : UserController.php
Model File name : User.php
View File name : index.blade.php
Table name : users
Columns     : id(primary),name,email, phone
To fetch all records from users table you can write in following 3 ways.
$users = DB::select(‘SELECT * FROM users’);
(or)
$users = DB::table(‘users’)->get();
(or)
$users = User::all(); //Here User is the model

Table:users

CREATE TABLE `users` (
  `id` int(10) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `name`, `email`, `phone`) VALUES
(1, 'smita', 'smita@gmail.com', '9861012345'),
(2, 'Smith', 'deep@gmail.com', '9861012346');


Controller: UserController.php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use Illuminate\Database\Eloquent\Model;
use App\User;

class UserController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {  
        $userobj = new User();
        $users = $userobj->getusers();
        return view(‘index’)->with(‘users’,$users);
    }
}

Model : User.php
<?php
namespace App;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Support\Facades\DB;

class User extends Model
{
       protected $table=”users”;
        public function getusers(){
            //$users = DB::select(‘SELECT * FROM users’);
            //$users = DB::table(‘users’)->get();
            $users = User::all();//User is the model here
        return $users;
   }

}
<?php

namespace App;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Support\Facades\DB;

class User extends Model
{
       protected $table=”users”;
        public function getusers(){
            //$users = DB::select(‘SELECT * FROM users’);
            //$users = DB::table(‘users’)->get();
            $users = User::all();//User is the model here
        return $users;
   }

}
View: index.blade.php

 <html>
    <table border="1">
        <tr>
            <td>Sl No</td>
            <td>Name</td>
            <td>Email</td>
            <td>Phone</td>
        </tr>
        @foreach($users as $key=>$user)
        <tr>
            <td>{{$key+1}}</td>
            <td>{{$user->name}}</td>
            <td>{{$user->email}}</td>
            <td>{{$user->phone}}</td>
        </tr>
        @endforeach
    </table>    
</html>