Since all of your data has a common link, i.e., userID, you may wish to make an series of JOIN's on the table.
SELECT A.userID, A.checkDate, A.CheckIN, B.LunchIn, C.LunchOut, D.CheckOut
LEFT JOIN CHECKIN B ON A.userid = b.userID
LEFT JOIN CHECKIN C ON A.userid = c.userID
LEFT JOIN CHECKIN D ON A.userid = d.userID
- I am assuming you cannot checkout, lunchin, lunch out unless you first check in as you can't do any of these until your actually "get there"
- Using LEFT JOIN, NULL's are returned automatically where there is not match.