Select data by status coloum in laravel 5

IN Custom php code

$select_query = "select * from admin where Stutes = '1' order by ID asc";

How we can embed this code in my this laravel 5 code

public function index()
{   
    $books=Book::all();
    return view('books.index', compact('books'));
}

via Chebli Mohamed