Passing Current User ID into SQL statement

No need to use []… just use simple single quotations (also no quotations does the job):

$sql ="
    SELECT 
    ...
    WHERE wp_users.`ID` = '$userID'";

OR

$sql ="
    SELECT 
    ...
    WHERE wp_users.`ID` = $userID";