select id to auto increment

SET @n=0;
SELECT @n := @n + 1  as mooban_id ,a.DISTRICT_CODE as mooban_code,  b.moobanname as mooban_name
FROM district a
INNER   JOIN cmooban b ON b.tumbon = a.DISTRICT_CODE