How to perform a query of a query stored in a string through the DB class?

Question

I wanted to convert this query how to use it in DB Facades Lavarel

SELECT FIND_IN_SET(KillCount, (SELECT GROUP_CONCAT(KillCount ORDER BY KillCount DESC) FROM users)) AS Rank FROM users WHERE id = 1

It takes the player’s rank position in the order of Kills from the entire server.

Updating

When using the whereRaw, as suggested, the following error occurs

For before he makes the montage of SELECT *

Answer 1

You can use the method DB::select directly. It allows you to execute a query from a string.

Behold:

$query = 'SELECT FIND_IN_SET(KillCount, (SELECT GROUP_CONCAT(KillCount ORDER BY KillCount DESC) FROM users)) AS Rank FROM users WHERE id = 1';

$resultado = DB::select($query);

Answer 2

You can use the method whereRaw() of Facade, it would look something like this:

\DB::table("users")->whereRaw("FIND_IN_SET(KillCount, (SELECT GROUP_CONCAT(KillCount ORDER BY KillCount DESC) FROM users)) AS Rank")
       ->where('id', 1)
       ->get();