mysql - make a query, get results make query again

Question

i want to execute these queries in a single statement :- How TO ??

SELECT count(id) as levela FROM `member` where parent_id in (SELECT id FROM `member` where parent_id in (SELECT id FROM `member` where parent_id = 2 )) 

SELECT count(id) as levelb FROM `member` where parent_id in (SELECT id FROM `member` where parent_id = 2)

SELECT count(id) as levelb FROM `member` where parent_id =  2

Answer 1

Use instead 'where', 'where in' - where in allows You to serach in array. for example :

Select id from member where parent_id IN (here array ($y) )