Not sure if I understand correctly but simply put a space in the separator string
CONCAT(Lastname,',',Firstname,' ',Middlename) as Fullname
However, remember that if any of the columns is null, the result is null. So you probably want to use
CONCAT(Lastname, ',', IFNULL(Firstname, ''), ' ' , IFNULL(Middlename, ''))