Undefined property: Illuminate\Database\Query\Builder

As i go along with my laravel journey, i found and encountered some errors and this is the one of them: "Undefined property: Illuminate\Database\Query\Builder::$id", i encountered this when i am trying to call a method on a controller, the show method inside a controller of-course there is a one parameter that is a id; and my code will look like this:

$cat = DB::table('category')->select('id','name','description')->where('id', $id)

so i found out that i forgot something, that there is a  method first() function, since i am retrieving a single or one row, in mySQL we can done it like this:

Select id, name From category where id = 1 LIMIT 1; 

so the solution is very simple by simply adding the first() method;

 $cat = DB::table('category')->select('id','name','description')->where('id', $id)->first()

and your good to go!!! Hope this will Help!!!

Happy Coding