
SELECT
c.id as c_id,
c.UserId as c_UserId,
c.PackId as c_PackId,
c.Credits as codes_Credits,
u.id as u_id,
u.Credits as u_Credits,
u.UserId as u_UserId
FROM codes c
JOIN tbl_gf_users u on u.UserId = c.UserId
WHERE u.UserId = 2