since you pass mid as integer values if you change your data type of mid to int, query execution will be faster.
following sample is based on mid as int
select e.name as Name,m.name as MID from mytable1 as e
left outer join mytable1 as
m on m.id = e.mid;