SELECT pd.id,pd.board_name name, pd.board_code code, upd.sort_num sortNum,upd.required_flag requiredFlag ,pd.link_url linkUrl,upd.checked_status checkedStatus
from t_bus_user_pc_dashboard upd
LEFT JOIN t_bus_pc_dashboard  pd
ON upd.boardid = pd.id
WHERE upd.userid =:userid
ORDER BY sort_num