Is it possible to list column entry only once?
I would say this is easier on the representational layer but if you want it in pure MySQL this will do it:

set @current='';
select show_basket, content 
from (
    select case 
        when @current = basket 
            then '' 
            else basket 
        end as show_basket, 
        content, @current:=basket 
    from test_131547
    order by basket
) a;


Output:

+-------------+---------+
| show_basket | content |
+-------------+---------+
| 1           | lemon   |
|             | lime    |
|             | apple   |
|             | banana  |
| 2           | kiwi    |
|             | apple   |
|             | orange  |
+-------------+---------+