SOS MYSQL

Selam arkadaslar,

i need an sql

  1. table ids KID 1,2,3,4,5,6,7
    2.second table is user (user_ID) 1,2,3,4,5,6,7,8,9…21,25
    3.third table connection
    User ID KID
    1 2
    2 3

what i want is , when i gave KID 2 i want something like that result
KID USERID
2 1
2 null
2 null
2 null
2 null
it should list all user whether it has in 3.th table or not

how can i do that with sql. thanks

LEFT OUTER JOIN.