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
See Question&Answers more detail:os