SELECT
@parentId AS _id,
(
SELECT
@parentId := parentId
FROM
justicegroup
WHERE
id = _id
) AS parent_id
FROM
(SELECT @parentId := 162) vars,
justicegroup
@parentId AS _id,
(
SELECT
@parentId := parentId
FROM
justicegroup
WHERE
id = _id
) AS parent_id
FROM
(SELECT @parentId := 162) vars,
justicegroup