You can concatenate the result from your query like this
SELECT concat(message_from, ' ', message_to) AS message FROM chat;
This is MySQL syntax, but the syntax should be similar in other flavors.
I agree with Mehdi, though, that you should consider to change your design.