how to use IN operator in laravel query (eleqouent and raw query)?

I need to use the IN operator to get the data from the database. I tried using it as below and got an error:

$pr =DB::('select * from prstuff p where p.pid in (select pid from prdrop)'); 

I am new to Laravel and don't know exactly how to use the operators like IN, so please explain to me how to use it.

via Chebli Mohamed