[SQL] Same IP count

SELECT  a.NAME,
        a.IP,
        (SELECT COUNT(ID) FROM USERS WHERE IP = a.IP AND STATUS = 1) AS C
FROM (
    SELECT  NAME,
            IP
    FROM USERS
    WHERE NAME = 'Laurynas_Leigon'
    LIMIT 1
) a